Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp owner=sys, system compress=y?
In article <8qqfdb$juo$1_at_news.sinet.slb.com>,
"Yong Huang" <yhuang_at_indigopool.com> wrote:
> I haven't tried but I heard that you CAN export SYS schema, only that
you
> cannot with a full database export. I.e., if you explicitly specify
> owner=SYS but without FULL=Y.
>
> Yong Huang
> yhuang_at_indigopool.com
>
> Howard J. Rogers <howardjr_at_www.com> wrote in message
> news:39d083e4_at_news.iprimus.com.au...
> > You can't export objects owned by SYS -which means the data
dictionary
> > tables are all un-exportable. And given that they should be the
only
> things
>
>
If this is going to work at all, which I don't believe, I'm confident
this still won't export the datadictionary.
IMO, what you heard should be considered as a fairy-tale, which doesn't
deserve to be distributed further and mislead other people.
Regards,
-- Sybrand Bakker, Oracle DBA All standard disclaimers apply ------------------------------------------------------------------------ Sent via Deja.com http://www.deja.com/ Before you buy.Received on Wed Sep 27 2000 - 00:09:22 CDT