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 the significance of the & and && operators in pl sql.
What is the difference between cross join and natural join?
How can a function retun more than one value in oracle with proper example?
What is your daily office routine?
Can function return multiple values in sql?
what is bcp? When does it used? : Sql dba
What is before trigger?
What are the different types of dbms?
Write a sql query to convert all character to uppercase after hypen.
What are the 3 modes of parameter?
What is the difference between delete, truncate and drop command?
What program will open a mdb file?
What is the difference between sql and t sql?
Can we use joins in subquery?
What is difference between sql and excel?