Oracle 9i/10g用户密码丢失SQLPlus怎么登录

UPDATE ORACLE(9i OR 10G) USER'S PASSWORD:

更改system密码为leian

C:>sqlplus /nolog

SQL>connect / as sysdba

SQL>alter user system identified by leian;

 

GET ORACLE VERSION MESSAGE:

获取Oracle 9i/10g版本信息,可以通过Oracle的系统视图获取,下面2个都可以

SQL>select * from v$version;

SQL>select * from product_component_version;

posted @ 2009-11-25 09:33  J&W  阅读(190)  评论(0)    收藏  举报