using comand prompt how can import table data and table
space with example
Answers were Sorted based on User's Feedback
Answer / raja
If u want to import only table data then you can opt for
sql loader and if u want to import the table sapce then you
can go for imp command
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / pradeep
imp command can be used for both table data and table space
import. Add one parameter for table data import (tables=
TABLE_NAME1,TABLE_NAME2).
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the most restrictive isolation level? : Transact sql
What are the components of a PL/SQL block ?
What is assignment operator in pl sql?
What is gpt format?
Is big data nosql?
We have a CURSOR then we need BULK COLLECT?
what are the type of locks ? : Sql dba
What is ttitle and btitle?
What are sql functions? Describe the different types of sql functions?
What is out parameter used for eventhough return statement can also be used in pl/sql?
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
Explain cursor types?
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)