table fetch continued row

From: Frederic Payant <no email>
Date: Thu, 17 Oct 2002 21:21:19 +0200
Message-ID: <dt2uqug7r51sr4l5k63ror20m9t2nf2njd@4ax.com>

Hi,
With Oracle 8.1.7 on Solaris 8 :

On a partitioned table we had to create a global unique index . At each time we create new partitions (ie every night) we have to rebuild this index.
OK
We had last night an error :
ORA-01502: index 'PIN.X_EVENT_ACT_CONTENT_AUTH_I1' or partition of such index is in unusable state

"insert into x_event_act_content_auth_t ( bla bla ... )" It was at the exact time where we rebuild indexes.

What's strange is that we rebuild indexes using the ONLINE clause :
"ALTER INDEX X_EVENT_ACT_CONTENT_AUTH_I1 REBUILD ONLINE NOLOGGING" If I read Oracle doc I find :
ONLINE :
Specify ONLINE to allow DML operations on the table or partition during rebuilding of the index. Restrictions:
1)You cannot specify ONLINE when rebuilding the secondary index of an index-organized table.
2)Parallel DML is not supported during online index building. If you specify ONLINE and then issue parallel DML statements, Oracle returns an error.

My table is not an index-organized table, and is created with no parallel options.

Is there anything I misunderstood ??

Thank for your help and don't hesitate to ask me any further information

Amicalement
Frédéric PAYANT Received on Thu Oct 17 2002 - 14:21:19 CDT