Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rebuilding table with LOB type INDEX

DBA_1Apr 28 2010 — edited Apr 28 2010
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2010
Added on Apr 28 2010
9 comments
19,539 views