expdp : Exporting datadump in Oracle 11g

The export can be done in two ways from local machine from Server From Local MachineFor Windows operating system Follow the steps# create directorycreate directory dmpdir as ‘c:/temp’;select directory_name,directory_path from dba_directories; # expdp ownercreate user scott identified by tiger;grant connect, resource to scott; grant read, write on directory dmpdir to scott;expdp scott/tiger@xe directory=dmpdir dumpfile=scott.dmp logfile=expdp.log …

expdp : Exporting datadump in Oracle 11g Read More »