1.创建表空间和用户echo "登录SQL*PLUS" 表空间用户.sql 后面跟四个参数,依次为:表空间名,数据文件路径,新建用户名,密码sqlplus "system/manager@ORCL as sysdba" @表空间用户.sql ts_name D:ORCL/oradata/ts_name.DAT user passpause
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 user3.导入数据imp user/pass@ORCL full=y file="文件位置.dmp" ignore=y
