1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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


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 CYCLE/NO CYCLE in a Sequence?

2 Answers  

Is pl sql better than sql?

0 Answers  

What is a parameter query?

0 Answers  

Why is theta join required?

0 Answers  

what is the difference between undefined value and null value? : Sql dba

0 Answers  




how to get a list of columns in an existing table? : Sql dba

0 Answers  

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

How can you fetch first 5 characters of the string?

0 Answers  

what are the type of locks ? : Sql dba

0 Answers  

What are conditional predicates?

0 Answers  

What are the two virtual tables available at the time of database trigger execution?

0 Answers  

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories