1.创建表空间和用户
echo "登录SQL*PLUS" 表空间用户.sql 后面跟四个参数,依次为:表空间名,数据文件路径,新建用户名,密码
sqlplus "system/manager@ORCL as sysdba" @表空间用户.sql ts_name D:ORCL/oradata/ts_name.DAT user pass
pause
2.授权
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW , DROP ANY
VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE, DBA,CONNECT,RESOURCE,CREATE SESSION
on user
3.导入数据
imp user/pass@ORCL full=y file="文件位置.dmp" ignore=y