国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁(yè) > 開(kāi)發(fā) > 綜合 > 正文

ORA-00701 warmstarting對(duì)象的另類解決方法

2024-07-21 02:32:36
字體:
來(lái)源:轉(zhuǎn)載
供稿:網(wǎng)友
    有朋友在ITPUB問(wèn)到一個(gè)問(wèn)題,如何resize一個(gè)SYSTEM表空間。     從常規(guī)來(lái)說(shuō),假如我們希望resize一個(gè)文件,這個(gè)文件能夠resize的部分必然是沒(méi)有數(shù)據(jù),未被使用的,也就是說(shuō),我們需要找到一個(gè)文件最高的Extent號(hào),這個(gè)Extent之外的空間是可以被resize的,以下一個(gè)查詢可以幫我們找到一個(gè)文件最末端的對(duì)象:
col segment_name for a30
col owner for a10
SELECT *
  FROM (SELECT   owner, segment_name,segment_type,block_id, blocks
            FROM dba_extents
           WHERE tablespace_name = 'SYSTEM' and file_id='&fileid'
        ORDER BY block_id DESC)
WHERE ROWNUM < 11;
看一下我的一個(gè)數(shù)據(jù)庫(kù):
SQL> col segment_name for a30
SQL> col owner for a10
SQL> SELECT *
  2    FROM (SELECT   owner, segment_name,segment_type,block_id, blocks
  3              FROM dba_extents
  4             WHERE tablespace_name = 'SYSTEM' and file_id='&fileid'
  5          ORDER BY block_id DESC)
  6  WHERE ROWNUM < 11;
Enter value for fileid: 1
old   4:            WHERE tablespace_name = 'SYSTEM' and file_id='&fileid'
new   4:            WHERE tablespace_name = 'SYSTEM' and file_id='1'
OWNER      SEGMENT_NAME                   SEGMENT_TYPE         BLOCK_ID     BLOCKS
---------- ------------------------------ ------------------ ---------- ----------
SYS        EYGLE_ip                       TABLE                   25609        128
SYS        EYGLE_IP                       TABLE                   25481        128
SYS        EYGLE_IP                       TABLE                   25353        128
SYS        I_H_OBJ#_COL#                  INDEX                   25305          8
SYS        TEST                           TABLE                   25297          8
SYS        I_TEST                         INDEX                   25289          8
SYS        TEST                           TABLE                   25281          8
SYS        T                              TABLE                   25273          8
SYS        EYGLE_IP                       TABLE                   25265          8
SYS        EYGLE_IP                       TABLE                   25257          8

10 rows selected.
我們注重到高水位上有些索引是可以通過(guò)rebuild來(lái)改變其位置的,但是在正常模式下,Oracle不答應(yīng)rebuild這些索引:
SQL> alter index I_H_OBJ#_COL# rebuild;
alter index I_H_OBJ#_COL# rebuild
*
ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered
有兩種方式可以使得這些對(duì)象答應(yīng)被重建:
1.通過(guò)migrate模式
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup migrate;
ORACLE instance started. Total System Global Area 139531744 bytes
Fixed Size 452064 bytes
Variable Size 121634816 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> alter index I_H_OBJ#_COL# rebuild;Index altered.SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 139531744 bytes
Fixed Size 452064 bytes
Variable Size 121634816 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
2.通過(guò)一個(gè)內(nèi)部事件
SQL> alter system set event='38003 trace name context forever, level 10' scope=spfile; System altered.SQL> startup force;
ORACLE instance started.Total System Global Area 139531744 bytes
Fixed Size 452064 bytes
Variable Size 121634816 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> alter index i_h_obj#_col# rebuild;Index altered.
38003事件的作用是:CBO Disable column stats for the dictionary objects in recursive SQL
也就是說(shuō)可以將部分對(duì)象從啟動(dòng)的bootstrap$需要里剝離出來(lái),從而可以被在線rebuild.這個(gè)事件能夠影響的對(duì)象很有限,這類操作也是極其危險(xiǎn)的,所以不在這里具體列出。-The End-http://www.eygle.com/archives/2007/02/ora_00701_warmstarting.Html

發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 五常市| 漾濞| 毕节市| 砚山县| 隆德县| 乌兰浩特市| 右玉县| 辰溪县| 浦江县| 达尔| 西华县| 石景山区| 甘谷县| 渭源县| 靖江市| 仪征市| 新蔡县| 昌乐县| 赣榆县| 和硕县| 晋中市| 无极县| 武穴市| 景泰县| 教育| 礼泉县| 西和县| 枞阳县| 衡阳市| 奇台县| 古蔺县| 平湖市| 金寨县| 巧家县| 鹿邑县| 隆安县| 定结县| 广饶县| 梧州市| 衢州市| 邯郸县|