RE: Need to move a table with a long

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Tue, 19 Dec 2000 11:45:15 +1100
Message-Id: <10714.124885@fatcity.com>

Scott,

• export table LONGTABLE
• rename table to LONGTABLE_BACKUP
• create table LONGTABLE tablespace DATA storage (initial ....) as select COLUMN1,COLUMN2,COLUMN3 ------- Select all columns except the LONG column from LONGTABLE_BACKUP;
• alter table LONGTABLE add (LONGCOLUMN LONG);
• run the import with ignore=y. This should import all the data into LONGTABLE.

HTH Suhen

-----Original Message-----
From: Scott Canaan [mailto:srcdco_at_ritvax.isc.rit.edu] Sent: Tuesday, December 19, 2000 6:31 AM To: Multiple recipients of list ORACLE-L 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:45:15 CST