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
What is sql rowcount?
What are dml commands?
What is equi join in sql?
What is field delimiter?
what is the bond code in materialized view?
Can we use ddl statements in stored procedure?
What is the difference between distinct and unique in sql?
Can we use rowid as primary key?
How do I view tables in mysql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is Histogram?
What is pl sql code?
Can we join 3 tables in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What are sql objects?