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 |
What is sql partition function?
How delete all data from all tables in sql?
How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?
Is truncate ddl or dml?
what are the advantages of sql ? : Sql dba
I want to execute a piece of code before calling a procedure. How to achieve it?
what is oracle database ? : Sql dba
Does sql*plus have a pl/sql engine?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is faster join or subquery?
How to get each name only once from an employee table?
How do you delete a table?
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)