迁移PDB文件

发布时间 2023-07-24 11:57:47作者: 捌玖

 

alter pluggable database PDB open;

!mkdir /u01/app/oracle/oradata/PRODCDB/PDB/datafile -p

alter database move datafile'/u01/app/oracle/oradata/PRODCDB/00CAB815B926863DE06383BEA8C0138A/datafile/o1_mf_sysaux_lcg1jf71_.dbf' to '/u01/app/oracle/oradata/PRODCDB/PDB/datafile/sysaux.dbf';
alter database move datafile'/u01/app/oracle/oradata/PRODCDB/00CAB815B926863DE06383BEA8C0138A/datafile/o1_mf_undotbs1_lcg1jf71_.dbf' to '/u01/app/oracle/oradata/PRODCDB/PDB/datafile/undotbs1.dbf';
alter database move datafile'/u01/app/oracle/oradata/PRODCDB/00CAB815B926863DE06383BEA8C0138A/datafile/o1_mf_system_lcg1jf6w_.dbf' to '/u01/app/oracle/oradata/PRODCDB/PDB/datafile/system.dbf';
alter database move datafile'/u01/app/oracle/oradata/PRODCDB/00CAB815B926863DE06383BEA8C0138A/datafile/o1_mf_users_lcg1jlro_.dbf' to '/u01/app/oracle/oradata/PRODCDB/PDB/datafile/users.dbf';

 

create temporary tablespace TEMP2 tempfile '/u01/app/oracle/oradata/PRODCDB/PDB/datafile/temp.dbf' size 100M autoextend on;

alter database default temporary tablespace TEMP2;

drop tablespace TEMP;