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 Difference between Procedure and Function.Can we call a Function in a DML?
Can we update views in sql?
what are properties of a transaction? : Sql dba
What is trigger in pl sql with examples?
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
Is a secondary key the same as a foreign key?
Is natural join same as inner join?
What is parameter substitution in sql?
Explain the working of primary key?
Is pl sql useful?
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?
29 Answers Alps, Aricent, Bank Of America, Wipro,
What does count (*) mean?
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)