fbpx

expdp : Exporting datadump in Oracle 11g

VijayaTech Labs Blog
Share on facebook
Share on twitter
Share on linkedin
Share on whatsapp
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 ).

Share this post with your friends

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Share on skype
Share on telegram
Share on whatsapp
Share on email

Leave a Comment

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

Scroll to Top