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 does t sql mean?
what are the nonstandard string types? : Sql dba
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What are literals in sql server?
what are the differences among rownum, rank and dense_rank? : Sql dba
Can two tables have same primary key?
Why schema is used in sql?
What is constant in pl sql?
What are records give examples?
What is acid property in a database?
What is meant by cursor in sql?
what is union, minus and interact commands? : Sql dba
What is the best free sql database?
How subquery works in sql?
What are character functions?