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;