Re: Moving long tables out of the SYSTEM tablespace. Yikes!

Dell BSM DBA wrote:
>
> 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

Hi Jack

1. Try the export/import utility for the specific tables (exp with tablename, impp with touser).
2. have a look at the SQL*Plus Copy command

HtH
eugen Received on Mon May 11 1998 - 00:00:00 CEST