Return-path: Envelope-to: oracle-l@orafaq.net Delivery-date: Fri, 20 Sep 2002 08:52:49 +0800 Received: from newsfeed.cts.com ([209.68.248.164]) by jean.onefuse.com with esmtp (Exim 3.36 #1) id 17sC2L-00022r-00 for oracle-l@orafaq.net; Fri, 20 Sep 2002 08:52:49 +0800 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id RAA92515; Thu, 19 Sep 2002 17:52:43 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004D47CE; Thu, 19 Sep 2002 17:03:23 -0800 Message-ID: Date: Thu, 19 Sep 2002 17:03:23 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "MacGregor, Ian A." Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "MacGregor, Ian A." Subject: RE: copying all schemas except sys Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT True, and if the original poster will check i believe he'll find those objects are not owned by sys but by system. Ian MacGregor Stanford Linear Accelerator Center ian@SLAC.Stanford.edu -----Original Message----- Sent: Thursday, September 19, 2002 12: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@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@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@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@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: MacGregor, Ian A. INET: ian@SLAC.Stanford.EDU 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@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).