Copy legacy Oracle tables with SQL*Plus

Friday Aug 15th 2008 by DatabaseJournal.com Staff

You may be running Oracle 10g Release 2, but the applications you're supporting may have been written much earlier. Tables developed in versions of Oracle prior to 8i often used the LONG datatype to store large amounts of text.

[From Builder AU]

With the introduction of Large Object (LOB) datatypes, the LONG and LONG RAW datatypes were deprecated. If you need to make a copy of a table that uses LONG, the CREATE TABLE AS SELECT syntax won't work; you'll get this error: ORA-00997: illegal use of LONG datatype.

The article continues at http://www.builderau.com.au/program/oracle/soa/Copy-legacy-Oracle-tables-with-SQL-Plus/0,339028441,339291273,00.htm

Mobile Site | Full Site