1、创建临时表:
create temporary tablespace mydb_temp
tempfile 'F:/oracle/product/10.2.0/oradata/mydb/mydb_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
路径:'F:/oracle/product/10.2.0/oradata/mydb/mydb_temp01.dbf'
maxsiz:最大容量
2、创建表空间
create tablespace EAS_D_GZWYJKH_STANDARD
logging
datafile 'F:/oracle/product/10.2.0/oradata/mydb/EAS_D_GZWYJKH_STANDARD.dbf'
size 64m
autoextend on
next 32m maxsize 2048m
extent management local;
3、创建用户
create user gzw identified by gzw
default tablespace EAS_D_GZWYJKH_STANDARD
temporary tablespace mydb_temp;
4、给用户授权
grant dba,connect,resource to gzw
5、导入备份库
imp gzw/gzw file=E:/gzw_V20090629.dmp log=F:/expdp/Fcms.log fromuser=GZWYJKH touser=gzw(其中 full=y有时候不能省略)