Re: Full import is not really "full"

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news: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

SYS only contains the dictionary, the dictionary is reconstructed as a result of import, so SYS is NEVER exported.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address