RE: Move selected tables

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Mon, 04 Aug 2003 08:39:35 -0800
Message-ID: <F001.005C8D40.20030804083935@fatcity.com>

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 are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
Sent: Monday, August 04, 2003 12:30 PM
To: Multiple recipients of list ORACLE-L

something like ...

set feed off
set echo off
set pages 0

select 'alter table '||table_name||' move tablespace NEW_TS;' from user_tables
where table_name like 'ABC_%'

spool move_tables.sql
/
spool off

would generate you a script to move your tables.

Cheers,
Mike

PS That's off the top of my head so exercise care when running it.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Mon Aug 04 2003 - 11:39:35 CDT