copying all schemas except sys

From: Ben <poelsb_at_post.queensu.ca>
Date: Thu, 19 Sep 2002 11:18:21 -0800
Message-ID: <F001.004D42E8.20020919111821@fatcity.com>

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). Received on Thu Sep 19 2002 - 14:18:21 CDT