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

Is stored procedure faster than query?

0 Answers  

Explain select statements in sql?

0 Answers  

what are all the common sql function? : Sql dba

0 Answers  

what is isam? : Sql dba

0 Answers  

What is the difference between microsoft access and sql server?

0 Answers  




What is clustered index in sql?

0 Answers  

What does inner join mean?

0 Answers  

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

What is oracle and pl sql?

0 Answers  

Does mysql support pl sql?

0 Answers  

How many primary keys can a table have?

0 Answers  

What are the most important ddl statements in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories