RPT_RECREATE_INDEX

This table stores SQL statement for Index creation from memory for rebuilding the deleted indexes.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

INDEX_SQL_ID

NOT NULL

NUMBER

System-generated identifier derived from sequence RPT_RECREATE_INDEX_SEQ

SQL_STMT

NOT NULL

VARCHAR2(4000)

SQL statement for Index creation from memory

Indexes

This table uses no indexes.

Sequences

Sequence Name

Sequence Type

RPT_RECREATE_INDEX_SEQ

INDEX_SQL_ID