Oracle10g import DMP

Prepare to export the database from the server to the Local Machine for testing. 1. Install oracle10g2 on the local machine to create a tablespace, 3. Create a user.

Prepare to export the database from the server to the Local Machine for testing. 1. Install oracle 10g2 on the local machine to create a tablespace. 3. Create a user in temporary tablespace.

Prepare to export the database from the server to the Local Machine for testing,

1. Install Oracle 10g on the local machine

2. Create a tablespace and a temporary tablespace

3. Create a user and be granted Permissions

First, start SQL * puls

Second, log in with system/manager

Third, create user username identified by password;

Fourth, grant create user, drop user, alter user, create any view,

Drop any view, EXP_FULL_DATABASE, IMP_FULL_DATABASE,

DBA, CONNECT, RESOURCE, create session to username; (do not forget the semicolon after the statement)

4. Assign the user a table space, a temporary table space, and a tablespace created in the second row.

5. Import the dmp file imp username/password in cmd @ rmis full = y file = d: file name. dmp ignore = y

The above is a test operation for oracle beginners. The summary is recorded here.