以下是plsql上运行的命令,passw命令无反应,而sqlplus中正常,请问是什么原因
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as scott
SQL> conn system
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as SYS
SQL> show user
User is "SYS"
SQL> passw
SQL> passw test
SQL> passw;
SQL>
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as scott
SQL> conn system
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as SYS
SQL> show user
User is "SYS"
SQL> passw
SQL> passw test
SQL> passw;
SQL>
解决方案 »
- 初学oracle,请教大家一些入门级的问题。
- 100分求一条数据导出语句
- oracle 11g em 首页里 listener 显示到实例的代理连接不可用,但是数据库的连接是正常的
- 大家帮忙看看,数据库空间占用比应该占用的大很多!
- sql问题 关于别名的join
- PROC中ORACLE数据库的游标以及CHAR型数据查询出来后的具体内容
- Oracle 创建自定义的流水号
- 我在XP下装了个Oracle 9.0,但系统一启动就自动启动了Oracle,想让系统启动时,不启动Oracle,怎么办?
- 安装oracle8.17时,配置工具中Net8 configuration Assistant这一项过不去了,请各位大侠指教!
- 请问如何在OEM中配置ORACLE Storage Manager
- 语法应该没什么问题啊
- 问一个loop游标fetch的问题
SQL> ALTER USER scott IDENTIFIED BY aaa ;
User altered
SQL>
不是所有的sqlplus命令都能在里面用
Changing User Identification: Example
The following statement changes the password of the user sidney (created in "Creating a Database User: Example") second_2nd_pwd and default tablespace to the tablespace example:ALTER USER sidney
IDENTIFIED BY second_2nd_pwd
DEFAULT TABLESPACE example;