Why you are not able to create a table using select
command,if it is having a LONG column?
for eg:create table test as select * from test1
here test1 containg a column having LONG datatype...
Answer Posted / hemant saini
Oracle Data Pump doesn’t give a chance for this and old
Export/Import utilities should be used
Oracle Data Pump Can’t Import LONG Columns
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain autonomous transaction.
Can a trigger call a stored procedure?
Can we use pl sql in sql server?
what tools available for managing mysql server? : Sql dba
what is table? : Sql dba
Can instead of triggers be used to fire once for each statement on a view?
Write a sql query to get the third highest salary of an employee from employee_table?
What does desc stand for?
What is left join in sql?
What is a rank in sql?
How do temporal tables work?
how to rename an existing table in mysql? : Sql dba
what is difference between delete and truncate commands? : Sql dba
What is composite data type in pl sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql