what is the use of EXP command ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist the various transaction phases.

792


What is database or database management systems (dbms)?

705


Do I need ccp4?

741


what is storage manager?

697


Where is data stored in a database?

707


Define database lock and its types.

673


Write about Transaction Management in Oracle 9i?

1848


What is a database management system and give examples?

642


Define b-trees.

682


What do you understand by fragmentation?

689


What is buffer manager?

698


Explain the advantages and disadvantages of a hierarchical database?

775


When would you use a database?

667


How rdbms is different from dbms?

665


What is database connection pool size?

663