Import tables with data pump

You can import specific tables with data pump by using the TABLES parameter.

impdp user/pwd directory=MY_DIR dumpfile=export.dmp logfile=import.log tables=schema1.table_name1,schema2.table_name2

Comments

Popular posts from this blog

Auditing user logon and logoff in Oracle

RMAN Restore vs. Recovery - what's the difference?