what is the use of EXP command ?

Question Posted / guest

2 Answers
7651 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 view is related to data independence?

0 Answers

How to determine who is and change the owner of database?

0 Answers

Define sub-query.

0 Answers

Write a query to remove duplicate rows from a table?