有关Oracle sqlplus的连接问题

在win7上运行oracle10g时,可能要以管理员权限运行。还有可能有其他问题,如:

ERRORORA-01017invalid usernamepassword

SQL> conn / as sysdba SQL> alter user SCOTT account unlock identified by tiger;

User altered.

SQL> select username,account_status from dba_users where username='SCOTT'; USERNAME                       ACCOUNT_STATUS ------------------------------ -------------------------------- SCOTT                                OPEN

SQL> conn scott/tiger Connected.

SQL> select * from tab;

posted on 2012-09-03 20:34  云端飘  阅读(171)  评论(0编辑  收藏  举报

导航