Oracle import and export operation

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

1, Gets the Oracle import and export help:

imp help=y

2,The export command

Exp username / password @ database instance file= file path name

Such as:

exp sys/password@orcl file=d:\data\test.dmp

3,Import command imp

Imp username / password @ database instance file= file path name fromuser= username

Such as:

Hypothesis: the exported DMP file the user is sys, the user is not test, then the command is as follows:

imp test/test@orcle file=d:\data\test.dmp fromuser=sys

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Terry at December 05, 2013 - 8:55 PM