SQL*Plus: Release 11.2.0.1.0 Production on 星期三 2月 24 14:59:54 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
请输入用户名: /as sysdba
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter user sys identified admin;
alter user sys identified admin
*
第 1 行出现错误:
ORA-00924: 缺失 BY 关键字
SQL> alter user sys identified by admin;
用户已更改。
SQL> conn sys/admin as sysdba;
已连接。
SQL> alert user system identified manager;
SP2-0734: 未知的命令开头 "alert user..." - 忽略了剩余的行。
SQL> alter user system identified manager;
alter user system identified manager
*
第 1 行出现错误:
ORA-00924: 缺失 BY 关键字
SQL> alter user system identified by manager;
用户已更改。
SQL> alter user system identified by system;
用户已更改。
SQL>
Copyright (c) 1982, 2010, Oracle. All rights reserved.
请输入用户名: /as sysdba
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter user sys identified admin;
alter user sys identified admin
*
第 1 行出现错误:
ORA-00924: 缺失 BY 关键字
SQL> alter user sys identified by admin;
用户已更改。
SQL> conn sys/admin as sysdba;
已连接。
SQL> alert user system identified manager;
SP2-0734: 未知的命令开头 "alert user..." - 忽略了剩余的行。
SQL> alter user system identified manager;
alter user system identified manager
*
第 1 行出现错误:
ORA-00924: 缺失 BY 关键字
SQL> alter user system identified by manager;
用户已更改。
SQL> alter user system identified by system;
用户已更改。
SQL>