Moving long tables out of the SYSTEM tablespace. Yikes!
Date: 1998/05/11
Message-ID: <35568626.61AC823B_at_texas.net>#1/1
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