oracle-databaseoracle12cdatapump

Export data using DataPump (SQL/PLUS, Oracle)


I need to copy whole schema("ABC") from one host to another one. I'm doing like this:

expdp user/pass@host dumpfile=test1.dmp logfile=test1.log schemas=ABC

Then I will import this file to my other host.

Can you please tell me, if it will copy everything? like package, procedures, triggers etc...?

Or I need to add something more?


Solution

  • Yes, it will copy everything.

    No, you don't need anything else.