ORA - 随笔分类 - Oracle

ORA-01002

摘要：ORA-01002: fetch out of sequence Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches, and thus may a... 阅读全文

posted @ 2009-02-26 15:10 Oracle 阅读(1564) 评论(0) 推荐(0)

ora-01722

摘要：ORA-1722 is Invalid number. We've attempted to either explicity or implicity convert a character string to a number and it is failing. This can happen for a number of reasons. It generally happens... 阅读全文

posted @ 2009-02-16 09:21 Oracle 阅读(1602) 评论(0) 推荐(0)

ORA-01045

摘要：user lacks create session privilege 解决办法：grant create session to username; 阅读全文

posted @ 2009-02-10 23:06 Oracle 阅读(1493) 评论(1) 推荐(0)

ora-01658

摘要：錯誤原因是表空間大小不足解決方法： 1.查詢各個表空間的利用率 select a.TABLESPACE_NAME, a.total,nvl(b.used,0) USED, nvl((b.used/a.total)*100,0) PCT_USED from (select TABLESPACE_NAME, sum(bytes)/(1024*1024) total from sys.dba_d... 阅读全文

posted @ 2009-02-10 15:10 Oracle 阅读(2932) 评论(0) 推荐(0)

随笔分类 - ORA