Ken, You can use a tables= option to list all the tables you want exported. And then use the fromuser= and touser= option to import them (to the right tablespace). Also, please remember that there is an upper limit on the number of characters in the tables= list. I can't remember the exact number, may be some one else can. (I think it is 2k or so). If this becomes a limitation, just export/impot a little less number of tables at a time. Good Luck.
- Kirti -----Original Message----- Sent: Friday, December 21, 2001 11:30 AM To: Multiple recipients of list ORACLE-L If you move with FULL=Y, you will move the entire database. Because you have placed objects in SYS, in violation of general DBA guidelines, you have forced this upon yourself. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -----Original Message----- Sent: Friday, December 21, 2001 11: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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
