expdp : Exporting datadump in Oracle 11g

The export can be done in two ways

  1. from local machine
  2. from Server

From Local MachineFor Windows operating system

Follow the steps
# create directory
create directory dmpdir as ‘c:/temp’;
select directory_name,directory_path from dba_directories;

# expdp owner
create user scott identified by tiger;
grant connect, resource to scott;


grant read, write on directory dmpdir to scott;
expdp scott/[email protected] directory=dmpdir dumpfile=scott.dmp logfile=expdp.log

# impdp owner
create user new_scott identified by tiger;
grant connect, resource to new_scott;
grant read, write on directory dmpdir to new_scott;
impdp new_scott/[email protected] directory=dmpdir dumpfile=scott.dmp remap_schema=scott:new_scott logfile=impdp.log

# other example
expdp system/[email protected] directory=dmpdir dumpfile=schemas.dmp logfile=expdp.log schemas=schema1,schema2
impdp system/[email protected] directory=dmpdir dumpfile=schemas.dmp logfile=impdp.log table_exists_action=replace schemas=schema1,schema2
impdp system/[email protected] directory=dmpdir dumpfile=schemas.dmp logfile=impdp.log table_exists_action=replace schemas=schema1,schema2 remap_tablespace=ts1:new_ts1 remap_schema=schema1:new_schema1

Resource @ GitHub

From Server

connect to putty (or any other utility to serve the commands in the server environment )
log in to the server
EXPORT SET ORACLE_HOME=”;

# create directory
create directory dmpdir as ‘/DATAPUMP’;
select directory_name,directory_path from dba_directories;

# expdp owner
create user scott identified by tiger;
grant connect, resource to scott;

# expdp owner
create user scott identified by tiger;
grant connect, resource to scott;

grant read, write on directory dmpdir to scott;
expdp scott/[email protected] directory=dmpdir dumpfile=scott.dmp logfile=expdp.log

Dump file and log file will be created in the given directory path ( /DATAPUMP ).

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top