Re: Insert append and indexes

"Sergey Adamenko" <asv_22_no_spam_at_softline.kiev.ua> wrote:

>
>>
>SB> The indexes will be invalid after the load due to the append option
>>
>
>
>Hi!
>
>Does that mean index invalid state?
>I've made a little test and see no index invalidataion.
>
>Sorry if I'm missing something.
>
>Best regards,
>Sergey Adamenko
>
>
>
>-----------------------------------------------
>SQL*Plus: Release 8.1.7.0.0 - Production on ×̣. ̉đâ 8 14:53:11 2003
>
>(c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
>Connected to:
>Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
>With the Partitioning option
>JServer Release 8.1.7.4.1 - Production
>
>SQL>
>SQL>
>SQL> drop table tap;
>
>Table dropped.
>
>SQL>
>SQL> create table tap (id number );
>
>Table created.
>
>SQL>
>SQL> create unique index idx_tap on tap(id);
>
>Index created.
>
>SQL>
>SQL> insert into tap values (1);
>
>1 row created.
>
>SQL>
>SQL> insert into tap values (2);
>
>1 row created.
>
>SQL>
>SQL> delete from tap;
>
>2 rows deleted.
>
>SQL>
>SQL> insert --+append
> 2 into tap
> 3 select obj#+1000 from sys.obj$;
>
>7478 rows created.
>
>SQL>
>SQL>
>SQL> select index_name, table_name, status from user_indexes;
>
>INDEX_NAME TABLE_NAME STATUS
>------------------------------ ------------------------------ --------
>IDX_TAP TAP VALID
>
>SQL>
>SQL>
>
>

Before the insert /* +append */ use the
alter table idx_tab nologging
and see if it still works without invalidating the index...The other issue may be that it is 'valid' but not 'correct' since it may not have 'read' the rowid of the bulk inserted rows...

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Thu May 08 2003 - 10:23:04 CDT