Some knowledge points for Oracle Import data ____oracle

Java EE Development of various types of resources download list, the history of the most complete IT resources, click to enter.

(1) Only DBAs can import files exported by other DBAs

Grant DBA to TestUser;

If not, in the execution:

Alter user testuser default role dba;

(2) Oracle Import DMP File command 1. First enter the CMD command window.
2. Executive Order: Imp userid= username/password @orcl file=d:\nc60.dmp full=y Explain user name: Is your target user. www.2cto.com Password: Is your target user login password. ORCL: Is the instance name is the database name. File: Is the full path of the DMP file you want to import. Full=y Whether this option can be used only when the current user is a DBA.