导入数据步骤

create temporary tablespace omgap_temp tempfile 'D:\oracledate\omgap\omgap_temp.dbf' size 3072m autoextend on next 50m maxsize 4048m extent management local;

create tablespace omgap logging datafile 'D:\oracledate\omgap\omgap_data.dbf' size 3072m autoextend on next 50m maxsize 4048m extent management local;

create user omgap identified by omgap default tablespace omgap temporary tablespace omgap_temp;

grant connect,resource,dba to omgap;

imp omgap/omgap@orcl file=D:\oracledate\omgap_20140509.dmp ignore=y full=y