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


Please Help Members By Posting Answers For Below Questions

How to create an array in pl/sql?

771


Is grant a ddl statement?

635


what is single byte over head in oracle..?

2088


What is information schema in sql?

761


What is the use of index in hive?

727






What are the methods of filing?

673


Is postgresql a nosql database?

790


Is pl sql and postgresql same?

767


Why is partition used in sql?

785


how to check server status with 'mysqladmin'? : Sql dba

783


What is a dynamic query?

760


Is vs as in pl sql?

670


What is the difference between pl and sql?

732


How would you reference column values before and after you have inserted and deleted triggers?

815


What is the difference between sql and t sql?

715