Data Pump Remote

http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19211-01/dp_import.html#9247

impdp hr/hr TABLES=employees DIRECTORY=dpump_dir1NETWORK_LINK=source_database_link EXCLUDE=CONSTRAINT REMAP_TABLESPACE=LABTEST1:LABTEST2

IMPDP system/****@ora1 SCHEMAS=COL1 REMAP_SCHEMA=COL1:COL2 REMAP_TABLESPACE=LABTEST1:LABTEST2 DIRECTORY=DBPUMP_DIR1 DUMPFILE=DUMP_ONLY_SCHEMA_COL1.DMP LOGFILE=DUMP_ONLY_SCHEMA_COL1.log

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License