create table test as select * from schema.table_name
where 1=2;
*
ERROR at line 1:
ORA-00997: illegal use of LONG datatype
This table has a long row in it and I am trying to make a copy of it and failing miserably. Any suggestions?
MH
Printable View
create table test as select * from schema.table_name
where 1=2;
*
ERROR at line 1:
ORA-00997: illegal use of LONG datatype
This table has a long row in it and I am trying to make a copy of it and failing miserably. Any suggestions?
MH
I managed to get the DDL from OEM and then created the table. I also used the create option in SQL*Plus's copy command, this worked too.
MH