Oracle 10g Recovery dmp file.

1. Under WinXP, install 10g, default selection, all the way OK. (Pre-install self-test with DHCP warning, can be ignored directly)

2. Command line, under XP, enter Sqlplus, you can start, login with Sqlplus/as sysdba with admin login

3. When restoring Oracle, first establish the tablespace, build the user, and grant the user authorization and unlock in Sqlplus.

----Create a table space

Create Tablespace jbpm
Logging
DataFile ' D:\oracle\product\10.2.0\oradata\jbpm.ora ' size 100M reuse
Extent management local segment space management auto;

----Create a user

Create User Jbpmuser
Identified by "Jbpmuser"
Default Tablespace jbpm
Temporary Tablespace Temp
Profile default
Quota Unlimited on jbpm;

Authorized
Grant connect to Jbpmuser;
Grant Exp_full_database to Jbpmuser;
Grant Imp_full_database to Jbpmuser;
Grant CONNECT,RESOURCE,DBA to Jbpmuser;

and unlock the user.

Alter user username account unlock;

4. In cmd, enter IMP to open the backup import system and log in with the user and user name you just created. Imp Jbpmuser/jbpmuser,

After landing, the interface displays Expdat. Dmp>, prompt. After entering D:/JBPM.DMP, you can import it.

When prompted to list only the contents of the import file, select No, object already exists, ignore create error, select No, other select Yes, (including permissions, table, entire file)

5. After importing, log in with Sqlplus jbpmuser/jbpmuser to view the table space,

Select table_name from User_tables;

The name of the table appears. The import is complete.

Oracle 10g Recovery dmp file.