
Oracle
yutianc
这个作者很懒,什么都没留下…
展开
-
ORA-00600 [19004],[],[],[],[],[],[],[]
ORA-00600内部错的消息总是让人沮丧。往往不知道具体原因。其实是因为返回的参数不同,原因分门别类有很多。今天遇到了一个,ORA-00600 返回参数[19004],[],[],[],[],[],[],[]1.执行的sql是镶嵌查询,单独拿出来里层的查询正常。2.返回来的数据不多,只有1700多条,确始终执行不过去,错误定位在里层表的那一位置。3.对错误定位的表执行分析...原创 2010-10-26 13:57:55 · 313 阅读 · 0 评论 -
Unable to create an instance of the Java Virtual Machine error
For Sql developer, may face such error after updated operation system patch.To Resolve this error please follow the below steps ;1- Open the ide.conf file located under jdev\bin\2- Edit :...原创 2012-05-16 13:41:35 · 281 阅读 · 0 评论 -
如何设置Oracle Sequence 的值
写道CREATE SEQUENCE gokhan.sample_seq START WITH 1000;SELECT last_numberFROM user_sequencesWHERE sequence_name = 'SAMPLE_SEQ';LAST_NUMBER-----------1000ALTER SEQUENCE gokhan.sample_seq INCREMENT BY ...原创 2014-11-12 17:50:04 · 454 阅读 · 0 评论