This content has been marked as final. Show 5 replies
Do a full database export.
If you have a USER SCHEMA export, and you areThe majority of your list is owned by SYS. so they are not included in user level export.
performing a schema import using Data Pump, will the
following be imported?
- Public Synonyms
- Public Database Links
- System privileges/grants
- Role grants
- Job Queues
If not, how may they be? I've looked in the Utilities
Guide, but nothing definite.
Thanks in advance.
Is it possible for the views within a database under a particular schema to be exported as well?
Yes, user's view will be included. I don't know why Oracle didn't provide a export/import mode listing for data pump like they did for Original export/import.
I suppost they are similar in term of what included in which mode.
Thanks yingkuan! Will try :)