what is the use of EXP command ?

Question Posted / guest

2 Answers
8070 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the use of EXP command ?..

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

what is the use of EXP command ?..

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

Post New Answer

More Database Management Interview Questions

how Data is stored in a file so that Direct Searching can be performed

0 Answers HCL,

What do you mean by durability in dbms?

0 Answers

What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW ?

2 Answers HCL,

What integrity rules exist in the dbms?