Re: moving tables from one tablespace to another

Jessie,

You could:

1. create table newtable tablespace new_tablespace storage (storage clause) as select * from oldtable;
2. rename oldtable to something else (if you want to keep it), and,
3. rename newtable to oldtable.

Of course, export will do other objects (indexes, constraints, etc.) for you. If you can recreate those, the solution above is simpler. There are scripts all over the net to recreate a table's objects. I don't have any that I use myself to recommend.

HTH, Yosi

Jessie Shu wrote:

> Hi! All,
> Does anyone have any good suggestion about moving tables from one
> tablespace to another? These tables have data inside. And currently we
> are going to
> 1) export those tables
> 2) drop them from DB
> 3) recreate them in new tablespace
> 4) import them with IGNORE=Y
> But I was wondering if there is a better way of doing this. Thanks!
Received on Tue Aug 17 1999 - 16:47:50 CDT