国产探花免费观看_亚洲丰满少妇自慰呻吟_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ā)表
主站蜘蛛池模板: 松潘县| 托克逊县| 建水县| 乌拉特后旗| 河源市| 梁平县| 汉源县| 佛教| 耿马| 临桂县| 美姑县| 永福县| 噶尔县| 泰来县| 民权县| 汝城县| 晴隆县| 互助| 广水市| 蒲城县| 吉隆县| 绩溪县| 外汇| 奉化市| 彭阳县| 于都县| 福贡县| 寿光市| 永靖县| 呼玛县| 阳曲县| 卢湾区| 灵寿县| 赤峰市| 吉林省| 城市| 鲁山县| 白山市| 赣州市| 平罗县| 松阳县|