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

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers Target,

What is clustered index in sql?

0 Answers

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers Polaris,

How long it takes to learn pl sql?

0 Answers

What is RAC in oracle?

7 Answers MCN Solutions,

what is view? : Sql dba

0 Answers

What does the acronym acid stand for in database management?