Sign Up Login


  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

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

What is sequence in sql?

0 Answers  

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

Can a select statement fire a trigger?

0 Answers  




What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

How is use pl and sql?

0 Answers  

How do I run sql profiler?

0 Answers  

what is try_catch block in procedure

0 Answers  

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

What is the left table in sql?

0 Answers  

What is cascade in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories