在cmd下输入
sqlplus /nolog
SQL>conn / as sysdba
SQL>grant dba to wen;
用户名: conn/as sysdba
然后创建root用户 并赋予权限
法一:
创建用户:
create user excar1 identified by excar1;
赋予权限:
grant dba to excar1;
然后
输入:conn excar1/excar1;
查询:
elect
* from user_sys_privs;
法二:
create user root identified by root;
default tablespace tablespacename;temporary tablespace temp;
grant dba to
root;
root 是用户名密码
http://www.cnblogs.com/shlcn/archive/2011/07/21/2112879.html