Pages

Friday, June 9, 2017

Export full database using data pump expdp

Create a directory.
  • cd /home/oracle
  • mkdir -p datapump/fullexport
Connect database using SYS user
  • sqlplus / as sysdba
Create a directory object
  • create a directory orcl_full as '/home/oracle/datapump/fullexport';
Grant read, write privileges on directory object and a rule 'datapump_exp_full_database' to hr user
  • grant read,write on directory orcl_full to hr;
  • grant datapump_exp_full_database to hr;


expdp hr/hr@oracle_4U DIRECTORY=orcl_full DUMPFILE=orclfull.dmp LOGFILE=full_exp.log FULL=yes;


TO fix this issue.

  • chmod 755 the permissions on the directory: $ORACLE_HOME/rdbms/xml/xsl
  • Re-load the stylesheets using the dbms_metadata_util.load_stylesheets procedure
  • execute dbms_metadata_util.load_stylesheets



Again fire the previous expdp command
Now it starts exporting.



Finish exporting.


 See the files.


No comments:

Post a Comment