Just this week I read Oracle encourages converting LONG to LOB's because
LONG will no longer exist in the next release. I thing I read it while
studying 9i New Features where a new DBMS package was described to convert
LONG to LOB type.
Paul Brewer <paul_at_paul.brewers.org.uk> schreef in berichtnieuws
3ddd6f8d_3_at_mk-nntp-1.news.uk.worldonline.com...
| "Paolo Quaglia" <paoloquaglia_at_hotmail.com> wrote in message
| news:arj0it$29rk$1_at_stargate1.inet.it...
| > Hi to all
| > I have created this table with a long data type
| >
| > CREATE TABLE content (
| > id_content number(16) NOT NULL,
| > data_contenuto date NOT NULL,
| > xml long
| > );
| >
| > My intention is to add a column before the xml field
| >
| > I have created another table with the new field
| >
| > CREATE TABLE content2 (
| > id_content number(16) NOT NULL,
| > data_contenuto date NOT NULL,
| > newfield varchar2(255),
| > xml long
| > );
| >
| > Now I HAVE TRIED TO COPY the vals from content to content2 using:
| >
| > INSERT INTO content2 SELECT * FROM content
| >
| > But Oracle says:
| >
| > ORA-00997: illegal use of LONG datatype
| >
| > How can I copy the data of a table with long to another diffirent
| > table??????
| >
| > Thanks very much to all!!
| > Paolo
| >
| >
| Version?
|
| The LONG answer to this could also be long, I'm sad to say.
| But another answer might be to CLOB the thing.
|
| And by the way, I do wish Oracle would practise as they preach, and remove
| longs from the data dictionary.
|
| Regards,
| Angry of Tunbridge Wells.
|
|
|
Received on Fri Nov 22 2002 - 12:47:54 CST
