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 dml statement?
What are the indexing methods?
Is mariadb a nosql database?
What is sql*loader and what is it used for?
How toimport .dmp file in lower version of oracle from higher version ?
explain mysql aggregate functions. : Sql dba
How does an execution block start and end in pl sql?
What is the command used to fetch the first 5 characters of a string?
How many types of database triggers can be specified on a table ? What are they ?
what is auto increment? : Sql dba
What does pl sql stand for?
what is 'mysqladmin' in mysql? : Sql dba
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)