C:\Users\hqbhonker>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 20 12:28:25 2013
Copyright © 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create tablespace QDII datafile ‘d:\1_workspace\QDHuaiTai.dbf’ size 2000m autoextend on next 100m extent management local;
Tablespace created.
SQL> create user huaitai identified by “1” default tablespace QDII;
User created.
SQL> grant resource,connect,dba to huaitai;
Grant succeeded.
SQL> connect huaitai/1
Connected.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Users\hqbhonker>imp huaitai/1 file=‘C:\Users\hqbhonker\Desktop\qdiifull20130909.dmp’ full=y