Oracle Database imp

Create a tablespace

Create tablespace ICITY datafile 'd: \ Oracle \ oradata \ orcl \ ICITY. dbf' size 400 M autoextend on next 10 M maxsize unlimited extent management local;

Create temporary tablespace

Create temporary tablespace ICITY_TEMP tempfile 'd: \ Oracle \ oradata \ orcl \ ICITY_TEMP.DBF 'size 100 M autoextend on next 10 M maxsize unlimited extent management local;

Create a user and specify the user tablespace

Create user icity identified by "12345678" default tablespace ICITY_ICP temporary tablespace ICITY_ICP_TEMP;

Assign User Roles

Grant dba to icity;

Import ICITY_ICP user data

Imp icity/12345678 @ orcl file = 'e: \ icity_icp201402.16.dmp 'fromuser = 'lily' touser = 'lily'; then