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

What is not null in sql?

0 Answers

how view used for security purposes?

3 Answers Glam India,

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

5 Answers Target,

If a cursor is open, how can we find in a pl/sql block?

0 Answers

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers

Is foreign key mandatory?

0 Answers

What is the difference between null value, zero, and blank space?

0 Answers

what is try_catch block in procedure

0 Answers

What is blind sql injection?

0 Answers

What is the difference between a query and a report?

0 Answers

explain advantages of innodb over myisam. : Sql dba

0 Answers

what are the advantages a stored procedure? : Sql dba

0 Answers

For more SQL PLSQL Interview Questions Click Here