Thursday, October 15, 2020

 

Oracle Data Pump (expdp, impdp) in Oracle Database 10g, 11g, 12c, 18c, 19c

https://oracle-base.com/articles/10g/oracle-data-pump-10g


# su - oracle

# .oraenv  (select prod)

# sqlplus / as sysdba


SQL> CREATE OR REPLACE DIRECTORY exp_db AS '/u02/db_export';

SQL> GRANT READ, WRITE ON DIRECTORY exp_db TO system;


# expdp system/manager@prod full=Y directory=exp_db dumpfile=prod.dmp logfile=expPROD.log

No comments:

Post a Comment

 RMAN Recovery Catalog About Recovery Catalog RMAN recovery catalog Is another database which is out of your normal databases or which is o...