Q1.Oracle9不支持以下语句?
A1:oracle不支持别名条件.Q2
ORA-03113 end-of-file on communication channelCause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.In addition, this message could occur when any of the following statements/commands have been issued:ALTER SYSTEM KILL SESSION ... IMMEDIATE
ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of Oracle Support Services.
ORA-03114 not connected to ORACLECause: A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.Action: Try again. If the message recurs and the program is user written, check the program.
A1:oracle不支持别名条件.Q2
ORA-03113 end-of-file on communication channelCause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.In addition, this message could occur when any of the following statements/commands have been issued:ALTER SYSTEM KILL SESSION ... IMMEDIATE
ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of Oracle Support Services.
ORA-03114 not connected to ORACLECause: A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.Action: Try again. If the message recurs and the program is user written, check the program.
解决方案 »
- 关于sql语句走索引问题欢迎大家讨论
- RAC环境,10.2.0.4.0,其中一个节点老实自动重启??
- ORACLE的CTC触发器
- Oracle查询排序
- 关于WINDOWS平台,和UNIX平台 ORACLE数据库连接问题。
- 高分请教高手如何用subquery怎么写这个语句
- 安装oracle客户端碰到的奇怪问题!
- 请问判断系统时间与某字段时间的差值?
- oracle外部连接怎么写?这条语句哪里错了?select n.news_id from news n outer join sp_news on sp_news.news_id=2
- 将查询出来的结果行转化为列
- 数据库事物处理问题
- 如何卸载ORACLE 9i?
你在子查询中定义了别名tCbo,这是在主查询中就可以调用tCbo作为字段的替代名了。
可我的服务器在本地机上,而且通过plsql developer执行其他sql语句没问题,再执行这条就出问题了,然后再执行其他的sql也没问题。