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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: copying all schemas except sys

RE: copying all schemas except sys

From: Ben <poelsb_at_post.queensu.ca>
Date: Fri, 20 Sep 2002 10:15:27 -0800
Message-ID: <F001.004D54EE.20020920101527@fatcity.com>


Hi

Well my import choked on the package SYS.DBMS_REPCAT_UTL so I assumed that there was SYS stuff in the full export.

-----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). Received on Fri Sep 20 2002 - 13:15:27 CDT

Original text of this message

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