Three ways Oracle Import and export DMP

1. Command line Parameters

For example: Exp scott/[email protected] tables=emp file=d:\test.dmp

2. Interactive prompt

For example: C:\users\administrator>exp + ENTER

Enter user name, carriage return

Input password, enter

Enter

Enter the path of the export

Enter

Enter...

3. parameter file

Create a new file Par.txt

Inside Input:

Userid=scott/[email protected]
Tables=student
File=d:\test.dmp

Save

Back to the command line: Input D: Enter, return to D drive

Input: Exp parfile=par.txt

　　　　

Three ways Oracle Import and export DMP