0

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?

4est
  • 3,010
  • 6
  • 41
  • 63

1 Answers1

1

Yes, it will copy everything.

No, you don't need anything else.

Littlefoot
  • 131,892
  • 15
  • 35
  • 57
  • You could have done it simply by testing it. Create user, export, import, compare. If something's wrong, drop user (you'll need the *cascade* option) and repeat the action. There's nothing you can do wrong, as long as you don't put that "new" user into production. Additionally, by performing export/import several times, using different options, will make you self-confident. Win-win situation, so - go ahead. – Littlefoot Jan 24 '18 at 13:11