Exp-imp to realize the migration of Oracle's different table space ____oracle



--1 on the migration target machine new
Create tablespace tzsb datafile ' I:\app\Administrator\oradata\orcl\tzsb01.dbf ' size 500m
Create user WGM_TZSB identified by pwd123 default tablespace tzsb temporary tablespace temp Quota unlimited on TZSB Accoun t unlock;
Grant create session to WGM_TZSB;
Grant CREATE table to WGM_TZSB;
Grant CREATE procedure to WGM_TZSB;
Grant create sequence to WGM_TZSB;
Grant CREATE view to WGM_TZSB;

--2 the table space name on the source computer (account: SYS/ORACLE@ORCL as SYSDBA login)

Alter tablespace EXAMPLE rename to TZSB;

--2, exporting users

Exp WGM_TZSB/PWE123@ORCL file=orcl.dmp Log=orcl-exp.log

--This DMP file tablespace should now be TZSB

--3, modify the table space name back (account: Sys/oracleas SYSDBA login)

Alter tablespace TZSB rename to EXAMPLE;

--4, import to the newly created user WGM_TZSB on target (default tablespace is TZSB, temporary tablespace is temp)

Imp WGM_TZSB/PWD123@ORCL file=c:\orcl.dmp full=y

All data is migrated to the new table space TZSB.