Why you are not able to create a table using select command,if it is having a

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...

Question Posted / santparkash

1 Answers
6587 Views
I also Faced
E-Mail Answers

Why you are not able to create a table using select command,if it is having a LONG column? for eg..

Answer / 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

More SQL PLSQL Interview Questions

Explain the update statement in sql

0 Answers

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers Wipro,

What is view? Can we update view

0 Answers

how to create a test table in your mysql server? : Sql dba

0 Answers

What does the base_object_type column shows in the user.triggers data dictionary view?

0 Answers

how will you find out the last three records in a table with n no of records and delete them

3 Answers

What is INSTEAD OF trigger ?

13 Answers Hexaware, TCS,

What is indexing oracle sql?