| Exporting Schemas |
| Export Parameters |
USERID=<user_id/password>
CONTENTS=
DUMPFILE=<path and name of dmp file>
EXCLUDE=
FILESIZE=
FULL=
JOBNAME=
LOGFILE=
NOLOGFILE=N/Y
PARALLEL=<integer>
PARFILE=
QUERY=
TABLES=<comma delimited list of tables> |
| Basic Table Export |
expdp hr/hr TABLES=employees,jobs
DUMPFILE=dpump_dir1:table.dmp NOLOGFILE=y |
CREATE OR REPLACE DIRECTORY
dpump_dir AS 'c:\temp';
GRANT EXP_FULL_DATABASE TO <schema_name>;
GRANT IMP_FULL_DATABASE TO <schema_name>;
EXPDP oe/oe TABLES=customers DUMPFILE=dpump_dir:xxx.dmp |
| Basic Export Demo |
|
| |
|