SQL*Plus (MOSC)

MOSC Banner

table from one schema to another

edited Oct 11, 2009 10:32PM in SQL*Plus (MOSC) 6 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center