> If you are using 8i you can move the tables. If not and you
> aren't ready to upgrade to 8i things are more comoplex.
> Basically what you want to do is export the tables you want to
> move, drop the tables, create the empty tables/indexes in the new
> tablespaces, and do an import with the ignore=y option. (I just
> moved 213 tables this way so I know it works.)
>
Try that
create table as select ... <with definition for the tablespace>
drop the old one
rename the new one to the origin name
problems may occure
- with index
- foreign keys
--
Regards
Nicolas Bronke
Received on Wed Nov 03 1999 - 08:42:57 CST
