http://jingyan.baidu.com/article/656db918b3fe44e381249c1c.html
1.远程桌面
mstsc.exe
sqlplus / as sysdba
2.cmd登陆oracle
删除删除用户EAMS_NWPU_0913,级所有和用户EAMS_NWPU_0913关联的数据
drop user EAMS_NWPU_0913 cascade;
3.
--创建用户
-- Create the user
create user EAMS_NWPU_0913 ---创建的用户名
identified by "eams" --创建的用户名密码
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant dba to EAMS_NWPU_0913;
-- Grant/Revoke system privileges
grant create any sequence to EAMS_NWPU_0913;
grant select any dictionary to EAMS_NWPU_0913;
grant select any table to EAMS_NWPU_0913;
grant unlimited tablespace to EAMS_NWPU_0913;
--导入
imp EAMS_NWPU_0913/eams@orcl buffer=64000 file=D:\tmp\EAMS_NWPU_0913.dmp log=D:\tmp\EAMS_NWPU_0913.log FULL=y;
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余2页未读,立即下载