Moving long tables out of the SYSTEM tablespace. Yikes!

All,

Have Oracle 7.3 database (NT 4.0) with user data tables in the system tablespace. Some of these tables have long datatype columns. Would like to move them into another tablespace so as not to interfere with data dictionary.

Cannot recreate tables elsewhere using "Create table x as (select from y)" since the long datatypes prevent this.

Cannot insert into new tables for the same reason.

Solution one: extract the data from these tables, recreate tables by hand, load data, recreate constraints.

Solution two: draw data from the long tables into MS Access tables, recreate the tables by hand elsewhere, insert data, recreate constraints.

Both of these options are unappealing, since these tables are at the heart of a 100+ table transaction system, and have a lot of data and a lot of constraints.

Any help greatly appreciated.

Regards,

Jack Received on Mon May 11 1998 - 00:00:00 CDT