Re: Move DB to Another Schema

Ken,

Do a full export as user sys. Then create a new userid to act as the owner of those non-sys and non-system tables. Do an alter user owner_of_tables default tablespace tablespace_for_application_tables;

Do an import of the application tables using the table (or tables - I can't remember) option of the imp command.
You probably will need to use fromuser=SYS touser=owner_of_tables as well.

>From the unix operating system prompt you can use the exp help=y and imp
help=y commands to get help on the syntax for export and import. The Server Utilities User's Guide has lots of text and examples for export and import. You can also query Metalink for something moving tables from one schema to another using export and import. There should
be a few notes in there outlining the exact steps to use.

Cherie

                                                                                       
                       
                    Ken Janusz                                                         
                       
                    <ken.janusz_at_su       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    fsys.com>            cc:                                           
                       
                    Sent by:             Subject:     Move DB to Another Schema        
                       
                    root_at_fatcity.c                                                     
                       
                    om                                                                 
                       
                                                                                       
                       
                                                                                       
                       
                    12/21/01 08:55                                                     
                       
                    AM                                                                 
                       
                    Please respond                                                     
                       
                    to ORACLE-L                                                        
                       
                                                                                       
                       
                                                                                       
                       

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: 
  INET: Cherie_Machler_at_gelco.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).