Too bad you are not using 9i. With 9i, in some cases, the "UPDATE
GLOBAL INDEXES" clause can be used with partition operations to update
global index automatically.
Frederic Payant <> wrote in message news:<dt2uqug7r51sr4l5k63ror20m9t2nf2njd_at_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 Fri Oct 18 2002 - 03:00:37 CDT
