Oracle 10 Gb import DMP

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.