CMD import DMP file for Oracle data

Orcale is already installed in the front, now import the database and start using it.

The steps are as follows:

1. Set table Space Auto-expansion

   1. Login with system as SYSDBA login password is empty

      650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/95/00/wKiom1kQgxKCLQi-AAAimtJH7RY244.png-wh_500x0-wm_ 3-wmp_4-s_1287558486.png "width=" "height=" 354 "alt=" Wkiom1kqgxkclqi-aaaimtjh7ry244.png-wh_50 "/>
      

   2. Query the physical path of the data file for the table system tablespace, with the statement
      

      SELECT file_name from Dba_data_files WHERE (tablespace_name = ' SYSTEM ')

      The result is: D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01. Dbf

   3. CREATE TABLE Space

      CREATE tablespace table Space datafile ' D:\APP\ADMINISTRATOR\ORADATA\ORCL\XXXX01. DBF ' size 200M autoextend on next 50M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

2. Create a user

A.create User

Identified by password DEFAULT tablespace table space

QUOTA UNLIMITED

On table space

QUOTA 100000 K

On USERS

Account UNLOCK;

3. Set User permissions

GRANT Connect,resource to User;

GRANT CREATE SESSION to user;

GRANT CREATE PROCEDURE to user;

GRANT DBA to User;

4. Import data (imported in CMD logout state)

Imp file=d:\xxx.dmp full=y;

5. Import data is complete.

6.cmd The statement that exports the data is

Exp User/Password @orcl file=d:\task-frame.dmp (preferably first built DMP file)

This article is from the "end of the shame" blog, please be sure to keep this source http://puregirl.blog.51cto.com/12887727/1923454

CMD import DMP file for Oracle data