table from one schema to another
While creating table of another schema I have this problem.
SQL> create table MSDP_CHARGING_TRANSACTIONS as select * from wsuser.MSDP_CHARGING_TRANSACTIONS;
create table MSDP_CHARGING_TRANSACTIONS as select * from wsuser.MSDP_CHARGING_TRANSACTIONS
*
ERROR at line 1:
ORA-00997: illegal use of LONG datatype
What is the solution.
SQL> create table MSDP_CHARGING_TRANSACTIONS as select * from wsuser.MSDP_CHARGING_TRANSACTIONS;
create table MSDP_CHARGING_TRANSACTIONS as select * from wsuser.MSDP_CHARGING_TRANSACTIONS
*
ERROR at line 1:
ORA-00997: illegal use of LONG datatype
What is the solution.
0