Oracle Database Data Pump import DMP file (detailed steps)

Step1, first know that you want to import the DMP files in the database (such as AA.DMP) is that version of the export (export imported version to be consistent, of course, 11g files can export 10g dmp files). Step2, in the Sqlplus command box with SYSDBA Administrator login, connect Sys/password as SYSDBA; Step3, create large data table space created tablespace mytable datafile ' e:\mytables1.dbf ' size 2014M segment space management auto; If the current datasheet is not enough, it prompts if the tablespace is not large enough to set the table space to automatically grow alter DATABASE datafile ' E:\MYTABLES1.DBF ' autoextend on; Step4, start importing data, first create directory directory object creation directory DIRDP as ' E:\backup ', and store the dmp file you want to import, you can manually set up a data file in E disk, put in DMP file, and then authorize to the database user, Grant Read,write on directory DIRDP to system; Step5, using data pump to import DMP files, the Import command is: IMPDP system/password directory=dirdp dumpfile=aa.dmp full=y.                                                                                         notes: For reference only