导航

2013年7月3日

摘要: ORA-01652 unable to extend temp segment by %s in tablespace %s 注意这里的temp segment并不一定就是指临时表空间, 也可能是其它的表空间,见下面描述Error: ORA-1652Text: unable to extend temp segment by %s in tablespace %s------- -----------------------------------------------------------------------Cause: Failed to allocate an extent fo 阅读全文

posted @ 2013-07-03 10:06 半夏_Fanxiaobo 阅读(371) 评论(0) 推荐(0)

2013年6月21日

摘要: 创建一个表: 记录rowid的分区段并作为处理的日志表:DROP TABLE DEAL_TABLE_EXTENT;CREATE TABLE DEAL_TABLE_EXTENT(seq number,OWNER VARCHAR2(30),TABLE_NAME VARCHAR2(30),EXTENT_ID NUMBER , FILE_ID NUMBER , BLOCK_ID NUMBER , BLOCKS NUMBER , RELATIVE_FNO NUMBER , MIN_ROWID ROWID,NEXT_ROWID ROWID,DEAL_FLAG NUMBER ,DEAL_ROW NUMBER 阅读全文

posted @ 2013-06-21 10:31 半夏_Fanxiaobo 阅读(308) 评论(0) 推荐(0)

2013年6月20日

摘要: One danger in making online backups is the possibility of inconsistent data within a block. For example, assume that you are backing up block 100 in datafile users.dbf. Also, assume that the copy utility reads the entire block while DBWR is in the middle of updating the block. In this case, the copy 阅读全文

posted @ 2013-06-20 10:28 半夏_Fanxiaobo 阅读(692) 评论(0) 推荐(0)

2013年6月17日

摘要: n this DocumentGoalSolutionThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation in this document a 阅读全文

posted @ 2013-06-17 11:21 半夏_Fanxiaobo 阅读(2519) 评论(0) 推荐(0)