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

From: Jared Hecker <jared_at_pandora.planet.net>
Date: 1998/05/11
Message-ID: <6j7cl4$9ra_at_jupiter.planet.net>#1/1


Longs are easily moved via PL/SQL. Create the table where you want it and write a simple looping stored procedure to move the records over one at a time.

hth -

Regards,
jh

Eugen Nyffeler (eugen.nyffeler_at_ubs.com) wrote:
: 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

--
Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **
Received on Mon May 11 1998 - 00:00:00 CEST

Original text of this message