Hi All,
I am getting "ORA-00997: illegal use of LONG datatype" this error.
I am accessing a view(Source : sql server data) through the dblink in my oracle db(destination).
The source view is having the LONG data type column( which is not changable) and am unable to convert it to CLOB/VARCHAR2 at the destination also.
- Tried with CTAS not worked.
- Tried to create the table at destination and INSERT INTO also not worked.
SOURCE SQL: >SELECT * FROM PS_FN_POMAP@dblink
DESTINATION:
>CREATE TABLE PS_FN_POMAP_TBL AS SELECT PS_PO_NUM,PS_REQ_ID,PO_NUM FROM PS_FN_POMAP@dblink;
Error: ORA-00997: illegal use of LONG datatype
>CREATE TABLE PS_FN_POMAP_TBL
(
PS_PO_NUM VARCHAR2 (100),
PS_REQ_ID VARCHAR2 (100),
PO_NUM VARCHAR2(100)
);
RESULT: TABLE CREATED.
>INSERT INTO PS_FN_POMAP_TBL SELECT * FROM PS_FN_POMAP@dblink;
Error: ORA-00997: illegal use of LONG datatype
Please suggest any other ways on how to access Source LONG data type as VARCHAR2/CLOB at Destination.
Thank you