Re: Insert append and indexes

From: Sergey Adamenko <asv_22_no_spam_at_softline.kiev.ua>
Date: Thu, 8 May 2003 15:02:06 +0300
Message-ID: <3eba47cf$1@ns>

>

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> Received on Thu May 08 2003 - 07:02:06 CDT