Home » SQL & PL/SQL » SQL & PL/SQL » CREATE TABLE with LONG datatype, shows error (Oracle 10g, O/S Win XP)
icon1.gif  CREATE TABLE with LONG datatype, shows error [message #410843] Tue, 30 June 2009 10:37 Go to next message
niladri
Messages: 14
Registered: January 2009
Location: USA
Junior Member
I have a table called MFG_PROGRAM_C with a long datatype. I am trying to bring the Structure and and the data from another Database (ORA10GR2) to my Test database ALPHA10GR2.

need your help....

This is what I am performing:-

CREATE TABLE MFG_PROGRAM_C AS
SELECT * FROM MFG_PROGRAM_C@ORA10GR2 ;

I get the following error:-

Error report:
SQL Error: ORA-00997: illegal use of LONG datatype
00997. 00000 - "illegal use of LONG datatype"

Table Structure:-
DESC MFG_PROGRAM_C ;
Name Null Type
------------------------------ -------- ------------------
ITEM_CDE VARCHAR2(50)
DESCRIPTION VARCHAR2(50)
REV_CDE NUMBER(15)
REV_DAT DATE
PC_PATH VARCHAR2(80)
PROGRAM LONG()

Re: CREATE TABLE with LONG datatype, shows error [message #410845 is a reply to message #410843] Tue, 30 June 2009 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot use LONG this way.
More DON'T USE LONG.

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Use code tags and the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Use SQL*Plus and copy and paste your session.

Regards
Michel

[Updated on: Tue, 30 June 2009 10:56]

Report message to a moderator

Re: CREATE TABLE with LONG datatype, shows error [message #410847 is a reply to message #410845] Tue, 30 June 2009 11:04 Go to previous messageGo to next message
niladri
Messages: 14
Registered: January 2009
Location: USA
Junior Member
I cannot change the table structure....this is manufacturing plant's machine's data table, LONG field contains Machine Programming, very large ASCII data..Used By the Assembling Machines, any other idea...?
Re: CREATE TABLE with LONG datatype, shows error [message #410848 is a reply to message #410847] Tue, 30 June 2009 11:23 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
* Use CLOB
* SQL*Plus COPY command
* Use PL/SQL to copy (if data < 32K)
* Use an external program
* Use export/import

Regards
Michel
Previous Topic: Maximum size for columns with Varchar
Next Topic: calculate first date of any month
Goto Forum:
  


Current Time: Mon Dec 05 07:08:08 CST 2016

Total time taken to generate the page: 0.07654 seconds