what is the use of EXP command ?
Answers were Sorted based on User's Feedback
Answer / charu
EXP command is a utility used for transferring the
structure /the data/indexes/statistics/tables/tablepaces
from a database.
More info can be got from exp help=y
Example Command is
exp username/password file=/absolutepath/ex.dmp tables=
(t1,t2,t3) statistics=none rows=y
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / guest
EXP command stands for EXPORT.This is used to transfer data
from one database to another database.To check all the
options in your system go to Start->run-><<type>> cmd----
>enter
<<type>>exp ---------->enter
| Is This Answer Correct ? | 1 Yes | 5 No |
What is the example of rdbms?
I have a table which has lot of inserts, is it a good database design to create indexes on that table?
What are different types of transaction isolation levels?
How do I convert a spreadsheet to a database?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
for what purpose we use MDM(master data management)tell me plz.
How do I create a database?
What are the key constraints in dbms?
What is difference between database and server?
What is a driver in programming?
What are the three levels of data abstraction?
What are 4 types of models?
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)