Re: moving tables between tablespaces

From: Ray Dutcher <rdutc_at_ia.mc.xerox.com>
Date: Fri, 14 May 1993 20:13:33 GMT
Message-ID: <1993May14.201333.26165_at_spectrum.xerox.com>

Johannes,

One way to move tables to another tablespace is:

1. export the tables you wish to move and associated indexes/grants if so desired.
2. drop the tables
3. create the tables in the destination tablespace. If you don't have the DDL then use the index option on the import to get the DDL and then modify the tablespace name in the DDL.
4. import the tables and associated indexes/grants if so desired.

OR you could use the

	 create table NEW_ONE
	 tablespace NEW_TBS
	 STORAGE..........
	 as select * from OLD_ONE

for each table and then drop OLD_ONE and rename NEW_ONE. In this solution you would have to recreate indexes and do the grants manually. I like the first solution better.

---
Ray Dutcher
Oracle DBA
Xerox Corp.
1350 Jefferson Rd., 801-15A
Rochester, NY 14623

Received on Fri May 14 1993 - 22:13:33 CEST