–创建用户

create user anhui identified by anhui

-给予用户权限

grant create session to anhui

grant connect,resource to anhui;

-创建表空间

1)先导dmp文件，报错：tablespace ‘FMIS_LOB’ does not exist

2)然后创建表空间

create tablespace FMIS_LOB DATAFILE ‘/data/db/shandong/FMIS_LOB.dbf’ Size 10240M AUTOEXTEND ON next 10M;

–加空间(空间不够时，加空间)

ALTER TABLESPACE rsapsr3 ADD DATAFILE ‘/data/shanghaiproject/rsapsr3_03.dbf’ Size 20480M AUTOEXTEND ON next 10M;

alter database datafile '/data/db/guiyang/FMIS1000.dbf' offline drop;

drop tablespace FMIS1000 including contents and datafiles;

create tablespace FMIS1000 DATAFILE '/data/db/guiyang/FMIS1000.dbf' Size 10240M AUTOEXTEND ON next 10M;

-导dmp文件

1) 用xshell连接服务器

2)连接之后，执行命令 su - oracle

3)执行命令

imp shandong/shandong@10.121.55.19/db file=/dat