Rebuilding table with LOB type INDEX
DBA_1Apr 28 2010 — edited Apr 28 2010Hi All,
I have to rebuild a table with LOB type index. Do I need to follow the same command ie *"alter table X move"* & *"Alter index Y rebuild online "* or there is some other ways to do the same.
Table structure :
<pre>SQL> desc aso.aso_order_feedback_t
Name Null? Type
----------------------------------------- -------- ----------------------------
Q_NAME VARCHAR2(30)
MSGID NOT NULL RAW(16)
CORRID VARCHAR2(128)
PRIORITY NUMBER
STATE NUMBER
DELAY DATE
EXPIRATION NUMBER
TIME_MANAGER_INFO DATE
LOCAL_ORDER_NO NUMBER
CHAIN_NO NUMBER
CSCN NUMBER
DSCN NUMBER
ENQ_TIME DATE
ENQ_UID NUMBER
ENQ_TID VARCHAR2(30)
DEQ_TIME DATE
DEQ_UID NUMBER
DEQ_TID VARCHAR2(30)
RETRY_COUNT NUMBER
EXCEPTION_QSCHEMA VARCHAR2(30)
EXCEPTION_QUEUE VARCHAR2(30)
STEP_NO NUMBER
RECIPIENT_KEY NUMBER
DEQUEUE_MSGID RAW(16)
SENDER_NAME VARCHAR2(30)
SENDER_ADDRESS VARCHAR2(1024)
SENDER_PROTOCOL NUMBER
USER_DATA SYSTEM.ASO_ORDER_FEEDBACK_TY PE
</pre>
<pre>SQL> select index_type ,count(*) from dba_indexes where table_name='ASO_ORDER_FEEDBACK_T' group by index_type;
INDEX_TYPE COUNT(*)
--------------------------- ----------
LOB 25
NORMAL 1
</pre>
Regds
Rahul