Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Full import is not really "full"
Rick Denoire <100.17706_at_germanynet.de> schreef in berichtnieuws
e7l0iv4q8t73ut7kp4lcaacj63dk2h7bc7_at_4ax.com...
| I created an empty DB with appropriate tablespaces in order to do a
| full import from another DB.
|
| It turned out that object privileges on SYS objects granted to an
| account in the source DB were not transfered to the destination DB
| after the full import (otherwise everything else went well). Is that
| the way it should work? So one can not rely that a full import is
| really full? This user is supposed to have select access on tables
| like all_users, v$session, etc. By the way, SYS password changed to
| that of the source DB! Funny.
|
| Bye
| Rick Denoire
And in addition: it's not only SYS objects that are not exported but the schemas ORDSYS, CTXSYS, MDSYS, ORDPLUGINS are not exported too. See Utilities Guide, chapter Export, paragraph Export modes. There is a nice table that shows what is exported/imported in the different export modes. Received on Fri Jul 25 2003 - 04:28:10 CDT