oracle 10g 安装时忘记建立一个scott帐号
<DIV><a href="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/201108/26/25958655_131436027136Wk.jpg" target="_blank"></A>这两天想学马士兵的Oracle.安装一下oracle 10g的，windows安装的时候忘记建立scott帐号了，晕。去网上找了一下。</DIV><DIV> </DIV>
<DIV> 首先在运行输入sqlplus，提示输入用户名: </DIV>
<DIV>输入用户名：sqlplus/as sysdba，密码为空，提示连接成功！</DIV>
<DIV> </DIV>
<DIV><BR>输入Sql代码</DIV>
<DIV> alter user scott account unlock; </DIV>
<DIV>再输入一句：<BR> alter user scott identified by tiger;</DIV>
<DIV> </DIV>
<DIV><a href="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/201108/26/25958655_131436027136Wk.jpg" target="_blank"><IMG src="http://blog.chinaunix.nethttp://blog.chinaunix.net/attachment/201108/26/25958655_131436027136Wk.jpg" .load="imgResize(this, 650);" border=0 ;></A></DIV>
<DIV> </DIV>
<DIV>好了，现在可以用账号scott和密码tiger登录了。搞定。</DIV>
<DIV> </DIV>
<DIV>借鉴：<a href="http://skyuck.iteye.com/blog/845225" target="_blank">http://skyuck.iteye.com/blog/845225</A></DIV>
<DIV><a href="http://chchl2007-126-com.iteye.com/blog/824255" target="_blank">http://chchl2007-126-com.iteye.com/blog/824255</A></DIV>
页:
[1]