Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: exp owner=sys, system compress=y?

Re: exp owner=sys, system compress=y?

From: <sybrandb_at_my-deja.com>
Date: Wed, 27 Sep 2000 05:09:22 GMT
Message-ID: <8qrvdv$55f$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US