Export from 11GR2 Oracle Database to pluggable 19c Database(data-pump)
Hello for all In this article we discuss how to import a particular schema from oracle database 11GR2(rac with two nodes) to a pluggable database version 19c Source : -- export import schema --- -- export BARIDIMOD SCHEMA --create file param in the source exp-schema.par --[kamal.khelifi.poste1] ➤ ssh oracle@10.100.0.55 -- Last login: Wed Jan 31 15:47:56 2024 from 192.168.0.55 -- step 1 : create new direcyory [oracle@rac1 ~]$ mkdir sqlldr [oracle@rac1 ~]$ -- EXP Preparation --- step 1 : Grant Read and Write Privileges on The Directory to schema1 user GRANT read, write ON DIRECTORY exp_schema TO schema1; [oracle@rac1 sqlldr]$ sqlplus / as sysdba SQL> GRANT read, write ON DIRECTORY exp_schema TO schema1; Grant succeeded. --- step 2 : create the parm fie vi exp-schema.par DIRECTORY=EXP_SCHEMA DUMPFILE=exp-sch-schema1-010224.dmp LOGFILE=exp-sch-schema1-010224.log SCHEMAS=schema1 METRICS=YES EXCLUDE=STATISTICS PARALLEL=6 [oracle@rac1 sqlldr]$ pw...