RE: copying all schemas except sys

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Thu, 19 Sep 2002 11:43:24 -0800
Message-ID: <F001.004D4374.20020919114324@fatcity.com>

Export program **never** exports the contents of SYS. WHy do you need a parameter IGNORE_SYS when it is ignored already?

-----Original Message-----
Sent: Thursday, September 19, 2002 12:18 PM To: Multiple recipients of list ORACLE-L

Starting with Oracle8i there is a problem with using full export and full import to re-create a database. The import coughs up a lot of errors due to the SYS schema (replication and help objects). How do people go about moving all the schemas from one instance to another without manually creating all the schema owners in the new instance and then exporting/importing every schema by name. What I want is an "ignore sys schema" parameter in the export utility.

Thanks,

Ben
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ben
INET: poelsb_at_post.queensu.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: K Gopalakrishnan
INET: kaygopal_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------