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...
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 |
How to pipe multiline string to isql?
What is recursive join in sql?
What are different types of triggers?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
what is the syntax for using sql_variant_property? : Transact sql
what is hash join
Is record in oracle pl sql?
What is the difference between the implicit and explicit cursors?
Are stored procedures faster than queries?
What is a database link?
How are sql commands classified?
What do you understand by case manipulation functions?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)