I'm an Oracle noob, and my intention is to transfer all data and metadata from one schema to another schema within an Oracle database. I'm planning to use datapump's
impdp commands. I have questions regarding this:
- Can I create a target schema without a user or should I create a user first (which creates a schema also)?
- Can I execute
impdpcommands using SYS (as sysdba) account? Is that a preferred method?
Does this statement take all the objects (data and metadata) from a schema and move these into a different schema?
expdp \"/ as sysdba\" schemas=<schemaname> directory=dumpdir dumpfile=<schemaname>.dmp logfile=expdp_<schemaname>.log
So is the target schema an exact copy of the source schema after