Target: Exporting and importing Oracle Data

1. Create directory for making location:

create directory as dirname ‘/usr/paul/home/location’

   2. Grant permission on that directory

grant read, write on directory dirname to username

  3. Export command

expdp user_id/pass@db_sid tables=, DIRECTORY=

DUMPFILE= LOGFILE=

  4. Import Command:

impdp user_id/pass@db_sid tables=, DIRECTORY=
DUMPFILE= LOGFILE=