what is the use of EXP command ?

Question Posted / guest

2 Answers
8842 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

What is correlated subquery in dbms?

0 Answers

how to pass values from one table to another by using Bulk collect?

3 Answers Oracle, Wipro,

Explain the difference between dbms and rdbms?

0 Answers

Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz

1 Answers

Differentiate nested loop, hash join and merge join.

0 Answers

Can an Alert message be changed at runtime ?

2 Answers

Which database server is best?

0 Answers

Mention the differences between unique key and primary key

0 Answers

How do I create a database in access 2010?

0 Answers

How do databases work?

0 Answers

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

0 Answers IBM,

What do you understand by sub-queries in sql?

0 Answers

For more Database Management Interview Questions Click Here