RE: Move DB to Another Schema

Ken,

SYS objects are NOT exported since an import of SYS would basically then import database metadata. The only method is to create another schema (not SYSTEM!) and move these tables into the new schema using a series of CTAS. If you have the DDL scripts, then run them against the new user rather than SYS (did you run them using SVRMGRL connected as INTERNAL before?)

Hope everything goes well with you and the family this Christmas season! John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Wanna know the reason for the season? Click on 'http://www.needhim.org'

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: Ken Janusz [mailto:ken.janusz_at_sufsys.com]
> Sent: Friday, December 21, 2001 8:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Move DB to Another Schema
>
>
> What about moving all the tables at one time (FULL=Y)? I
> have about 150
> just for the application. And another bunch for the DB.
>
> -----Original Message-----
> Sent: Friday, December 21, 2001 9:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Move DB to Another Schema
>
> Ken.
> After creating the user, you can use export to move the
> tables one at a
> time. You will need to specify the owner of the table on the
> export (ie:
> SYS.table name) and then on the import you will say
> FROMUSER=SYS TOUSER=xxx
> on the command line. I would suggest examining the Utilities
> guide for
> additional information.
>
> Thank You
>
> Stephen P. Karniotis
> Technical Alliance Manager
> Compuware Corporation
> Direct: (248) 865-4350
> Mobile: (248) 408-2918
> Email: Stephen.Karniotis_at_Compuware.com
> Web: www.compuware.com
>
>
> -----Original Message-----
> Sent: Friday, December 21, 2001 9:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Move DB to Another Schema
>
> I can't find any details of this in any of my documentation.
> I originally
> created my DB as SYS. I have setup a new user and need to
> move my DB /
> Tables, etc. to the new schema. How do I go about this? Can
> I do it via
> SQL Plus or do I need to do it via svrmgr? Or, would it just
> be easier to
> create a new DB (DDL SQL script) as the new user?
>
> Thanks,
> Ken Janusz
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
> INET: ken.janusz_at_sufsys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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: Karniotis, Stephen
> INET: Stephen_Karniotis_at_compuware.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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: Ken Janusz
> INET: ken.janusz_at_sufsys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).