Re: Export/Import ... Discussions

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Jul 2001 21:37:08 GMT
Message-ID: <tkvif7163rsg11@beta-news.demon.nl>

"JK Yao" <jkyf0131_at_hotmail.com> wrote in message news:93f65984.0107131827.562c637a_at_posting.google.com...
> I got the information from Oracle Document that Full Database EXport
> using Export won't export objects in the schema of SYS, so should not
> create any object under SYS. Is that correct? So, will there have
> any problem when upgrade database by using Export/Import Utility to
> import data?
>
> If it will, how can I solve this problem?
> Any comment will be very appreciated.
> Take in advance,
>
> JK
> a very Jr. DBA

Yes, SYS is not exported as SYS contains the datadictionary. The datadictionary is updated by creating tables etc. So Yes, you should not create anything under SYS and Yes, SYS is automatically restored as a result of any create table statement etc.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sat Jul 21 2001 - 16:37:08 CDT