RE: copying all schemas except sys

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Fri, 20 Sep 2002 13:28:30 -0800
Message-ID: <F001.004D5A3A.20020920132830@fatcity.com>

Try setting the GLOBAL_NAMES parameter in the init.ora file to FALSE for the target database.

RWB "Ben" <poelsb_at_post.queensu.ca>@fatcity.com on 09/20/2002 01:21:34 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Hi

Well my import choked on SYS.DBMS_REPCAT_UTL so I just assumed that there was SYS schema stuff in the full export. I see now that the import must execute this package. This package was having a problem with the fact that the exported global name did not match that of the instance I was importing into. How do I avoid this problem? I don't want to have to delete the replications stuff out of the instance before I export.

Ben

-----Original Message-----

Gopalakrishnan
Sent: September 19, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L

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

KG

-----Original Message-----

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

Hi

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


---------------------------------------------------------------------

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: 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:
  INET: Reginald.W.Bailey_at_jpmorgan.com

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). Received on Fri Sep 20 2002 - 16:28:30 CDT