Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Index unusable rebuild
I have several jobs which create some read-only tables:
drop table t1;
create table t1 NOLOGGING pctfree 0 as select...;
create index i1 NOLOGGING pctfree 0...;
I would like to truncate the tables and indexes rather than drop them (I would like to be able to make persistent changes to storage parameters). I would like these operations to be performed with nologging. I have tried:
truncate table t1;
alter index i1 unusable;
insert /*+APPEND */ into t1 NOLOGGING select...;
alter index i1 rebuild NOLOGGING;
However, I am getting (something like) the following error:
ERROR at line 1:
ORA-26028: index I1 initially in unusable state
How can I instruct Oracle to ignore an existing index during a direct-path insert? How can I establish a NOLOGGING operation for both the table and index rebuild?
/ Charles J. Fisher |"Dig within. There lies the spring / / cfisher_at_rhadmin.org | of good: ever dig, and it will / / http://rhadmin.org | ever flow." -Marcus Aurelius / ---------------------------------------------------------------------------Received on Tue Jul 22 2003 - 12:50:46 CDT