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 are the differences between binary and varbinary? : Sql dba
Can we use insert statement in function?
What is prepared statement in sql?
Can you sum a count in sql?
Types of joins ?
what is self join and how it works??
What is a unique key?
Write the command to remove all players named sachin from the players table.
can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
What is an ndf file?
What is procedure in pl sql?
What is crud sql?
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)