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.