Migration using Datapump 12c to 19c

 Major Steps

> Export user,role,profile from 12c databases.

> Import user,role,profile to 19c database.

>Export schemas from 12c/11g database.

>Import schemas to 19c database.

Source Server

$sqlplus / as sysdba

sql>! mkdir /u01/export

sql>create directory export as '/u01/export';

sql>exit

$expdp directory=export dumpfile=user_role_profile.dmp logfile=user_role_profile_expdp.log full=y include=user,role,role_grant,profile 

$expdp directory=export dumpfile=test_schema.dmp logfile=test_schema_expdp.log schemas=test

 

Dest server

mkdir /u01/import

 

Source server

cd /u01/export

scp * oracle@111.111.11.11:/u01/import

 

Dest Server

sqlplus / as sysdba

create directory import as '/u01/import';

exit

create tablespace same as source for test schema

select tablespace_name from dba_segments where owner='TEST';

SELECT DBMS_METADATA.GET_DDL('TABLESPACE','&TABLESPACE_NAME') FROM dual;

 

$impdp directory=import dumpfile=user_role_profile.dmp logfile=user_role_profile_impdp.log full=y include=user,role,role_grant,profile 

$impdp directory=import dumpfile=test_schema.dmp logfile=test_schema_impdp.log schemas=test

 

Ref https://www.youtube.com/watch?v=mYQ5OvSaSFI