moving from tablespace a to tablespace b

If I am the DBA for my database how do I move a set of ~100 tables from one tablespace to another. They are all my tables.

Each time I try it, import tries to reload them into the old tablespace, eventhough I've changed my default tablespace to the new tablespace and removed the unlimited tablespace priviledge. I don't want to drop the old tables until I am sure that they have been imported into the new tablespace.

Any suggestions?

Please email me directly

-Chris Wasser
chrisw_at_astragalus.cnr.colostate.edu Received on Thu Apr 11 1996 - 00:00:00 CEST