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

Is it possible to create startup or shutdown trigger for on-schema?

0 Answers

What is function and procedure?

0 Answers

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers

What is Primary Key?

4 Answers Ramco,

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers Keane India Ltd,

what is the use of double ampersand (&&) in sql queries?

0 Answers

explain the difference between myisam static and myisam dynamic. : Sql dba

0 Answers

what is difference between procedure and function, procedure and trigger?

8 Answers iFlex,

Name the different types of indexes in sql and define them.