Re: Need to move a table with a long

A couple of advanced ways:

Create table as select and redo all further changes using the log miner.

Create a new table, create a trigger on the old table to reproduce all the DML to the new table, and copy the data using a cursor loop. This is just a general concept, some caution should be exercised - the copy loop should go record by record and lock the record before copying it so that it is not changed at the same time as it is copied. As far as I could think the requirement is that the table has a primary key. I tried it on a couple of occasions and it worked.

In both cases you will have small downtime when swapping the tables.

Djordje

• Original Message ----- From: Scott Canaan <srcdco_at_ritvax.isc.rit.edu> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, December 18, 2000 2:30 PM Subject: Need to move a table with a long

> I need to move a table to another tablespace. Normally, I would do
> this with alter table move ..., but the table has a long column and I
> get an error that says that it's an illegal use of a long column. How
> should I move this table? I am on Oracle 8.1.6.0, on Compaq Tru-64
> (Digital) Unix 4.0d.
>
> Thank you,
>
> --
> Scott Canaan (srcdco_at_rit.edu)
> "Life is like a sewer, what you get out of it depends on what you put
> into it" - Tom Lehrer
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott Canaan
> INET: srcdco_at_ritvax.isc.rit.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Dec 18 2000 - 18:10:18 CST