Move selected tables

2003-08-04 Thread Smith, Ron 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

RE: Move selected tables

2003-08-04 Thread Ramon E. Estevez
, 2003 12:14 PM To: Multiple recipients of list 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

RE: Move selected tables

2003-08-04 Thread Hately, Mike (LogicaCMG)
head so exercise care when running it. -Original Message- Sent: 04 August 2003 16:14 To: Multiple recipients of list 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

Antw: Move selected tables

2003-08-04 Thread Guido Konsolke
] 04.08.2003 18.14 Uhr 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

RE: Move selected tables

2003-08-04 Thread Nelson, Allan
for both. Allan -Original Message- Sent: Monday, August 04, 2003 11:14 AM To: Multiple recipients of list 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

RE: Move selected tables

2003-08-04 Thread Hately, Mike (LogicaCMG)
Bugger. I missed the schema bit didn't I. Never mind, back to the drawing board ... Mike -Original Message- Sent: 04 August 2003 16:14 To: Multiple recipients of list ORACLE-L I need to move selected tables from one schema to another schema within the same database. The tables I

RE: Move selected tables

2003-08-04 Thread Jamadagni, Rajendra
Title: RE: Move selected tables I thought the tables were changing their ownership (schema) not the address (tablespace) Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email

RE: Move selected tables

2003-08-04 Thread Mercadante, Thomas F
, August 04, 2003 12:14 PM To: Multiple recipients of list 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

RE: Move selected tables

2003-08-04 Thread Mercadante, Thomas F
tables afterwards assuming you have space for both. Allan -Original Message- Sent: Monday, August 04, 2003 11:14 AM To: Multiple recipients of list 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

Re: Move selected tables

2003-08-04 Thread Reginald . W . Bailey
] Sent by: cc: [EMAIL PROTECTED] Subject: Move selected tables

RE: Move selected tables

2003-08-04 Thread Sarnowski, Chris
selected tables 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

RE: Move selected tables

2003-08-04 Thread Smith, Ron L.
recipients of list ORACLE-L Subject: Move selected tables 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

RE: Move selected tables

2003-08-04 Thread Robson, Peter
To: Multiple recipients of list 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

Re: Move selected tables

2003-08-04 Thread Tanel Poder
, August 04, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: Move selected tables 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

Re: Move selected tables

2003-08-04 Thread Tanel Poder
Hi! Right - but it is quite easy to use the dynamic SQL already illustrated in an earlier email reply (eg below) to capture the entirety of the DDL for a suite of tables, and transpose the whole lot into a new schema. In fact, I am doing this sort of thing repeatedly, as our users areas are

RE: Move selected tables

2003-08-04 Thread Jamadagni, Rajendra
Title: RE: Move selected tables exp tables ... imp fromuser=old_user touser=new_user Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod