Oracle-L: Re: Move selected tables

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Mon, 04 Aug 2003 09:04:28 -0800
Message-ID: <F001.005C8D4D.20030804090428@fatcity.com>

Try using the SQLPlus command COPY or the SQL command create table xxyy AS SELECT * FROM dddrrr. Or use OEM or some other GUI tool.

RWB

Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) reginald.w.bailey_at_jpmorgan.com
baileyre_at_us.ibm.com

                                                                                                                            
                    rlsmith_at_kmg.co                                                                                          
                    m                    To:     ORACLE-L_at_fatcity.com                                                       
                    Sent by:             cc:                                                                                
                    ml-errors_at_fatc       Subject:     Move selected tables                                                  
                    ity.com                                                                                                 
                                                                                                                            
                                                                                                                            
                    08/04/2003                                                                                              
                    11:14 AM                                                                                                
                    Please respond                                                                                          
                    to ORACLE-L

I need to move selected tables from one schema to another schema within the same database. The tables I need to move all start with the same prefix (abc_sometablename). Say there are 200 tables out of 1000 that I want to move. Is there an easy way to do this?

Thanks!
Ron

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
  INET: rlsmith_at_kmg.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_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.net
-- 
Author: 
  INET: Reginald.W.Bailey_at_jpmorgan.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_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 Mon Aug 04 2003 - 12:04:28 CDT