Oracle

时间比较
摘要: to_char(时间字段,'mi')阅读全文

posted @ 2006-06-30 16:43 .Dove 阅读(78) | 评论 (0) 编辑

远程主机强迫关闭了一个现有的连接
摘要: 远程主机强迫关闭了一个现有的连接错就错呗,乱报错误阅读全文

posted @ 2006-06-07 15:20 .Dove 阅读(3184) | 评论 (1) 编辑

Connect internal only, until freed.
摘要: 休息了个周末,今天早上一登陆,就报此错误ORA-00257: archiver error. Connect internal only, until freed. 这种错误是怎样造成的?阅读全文

posted @ 2006-04-24 10:23 .Dove 阅读(340) | 评论 (0) 编辑

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."
摘要: 数据保存出此错误信息:Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.经查是因为做了一个备份表,而影响了数据表tablename的结构,导致pk不见,而备份tablename1的p...阅读全文

posted @ 2006-04-17 11:45 .Dove 阅读(1154) | 评论 (0) 编辑

存储过程

posted @ 2006-03-30 10:20 .Dove 阅读(34) | 评论 (0) 编辑

Server was unable to process request. ---> ORA-01000: 超出打开游标的最大数

posted @ 2006-03-21 10:07 .Dove 阅读(332) | 评论 (0) 编辑