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 are the types of join and explain each?

0 Answers  

How can I get the number of records affected by a stored procedure?

0 Answers  

What is scope of pl sql developer in future?

0 Answers  

Explain the purpose of %type and %rowtype data types?

0 Answers  

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  




What is query execution plan in sql?

0 Answers  

What is a crud api?

0 Answers  

What is sharding in sql?

0 Answers  

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

Why do we use joins?

0 Answers  

What is rtm stands for?

0 Answers  

What is partition in sql query?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories