Oracle Import. dmp files

In daily development, it is often necessary to import a. dmp file into a database, below is a brief introduction to how to import from a command

1. Create a AWSBPM user
Create user username identified by password;

Example: Create user test identified by test;

2. The user gives the appropriate permission, the privilege is better to be higher.
Grant CONNECT,RESOURCE,DBA to test;

3. Thedmp file is imported into Oracle, buffer is best for larger

Imp userid= 'sys/[email protected] as Sysdba' file=f:\awsbpm.dmp rows=y fromuser=test touser=test Statistics=none buffer=10000000

Oracle Import. dmp files