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-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time https://shivanandarao-oracle.com/2012/12/05/rman-20207-until-time-or-re...