DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_INDEXES

Object Details
Object Name: FND_INDEXES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_INDEXES
Subobject Name:
Status: VALID


FND_INDEXES stores information about the registered indexes
in your applications. Each row includes the name and a
description of the index. Each row also contains information about
the storage parameters for the index and a flag (AUTO_SIZE) which
indicates whether the install should automatically apply a sizing
factor to the storage parameters. You need one row for each
index in each application. Oracle Applications uses this
information when installing and upgrading the database.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_INDEXES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnAPPLICATION_ID
ColumnTABLE_ID
ColumnINDEX_ID
FND_INDEXES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnINDEX_NAME
ColumnAPPLICATION_ID
ColumnTABLE_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application identifier
TABLE_ID NUMBER (15) Yes Table identifier
INDEX_ID NUMBER (15) Yes Index identifier
INDEX_NAME VARCHAR2 (30) Yes Index name
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
AUTO_SIZE VARCHAR2 (1) Yes Is this index automatically sized during an install?
INI_TRANS NUMBER (15) Yes Initial number of transactions
MAX_TRANS NUMBER (15) Yes Maximum number of transactions
INITIAL_EXTENT NUMBER (15) Yes Initial extent
NEXT_EXTENT NUMBER (15) Yes Next extent
MIN_EXTENTS NUMBER (15) Yes Minimum extent
MAX_EXTENTS NUMBER (15) Yes Maximum extent
PCT_FREE NUMBER (15) Yes Percent of free space
PCT_INCREASE NUMBER (15) Yes Percent of free space to increase
UNIQUENESS VARCHAR2 (1) Yes Uniqueness
DESCRIPTION VARCHAR2 (240)
Description
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLICATION_ID
,      TABLE_ID
,      INDEX_ID
,      INDEX_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      AUTO_SIZE
,      INI_TRANS
,      MAX_TRANS
,      INITIAL_EXTENT
,      NEXT_EXTENT
,      MIN_EXTENTS
,      MAX_EXTENTS
,      PCT_FREE
,      PCT_INCREASE
,      UNIQUENESS
,      DESCRIPTION
FROM APPLSYS.FND_INDEXES;

Dependencies

[top of page]

APPLSYS.FND_INDEXES does not reference any database object

APPLSYS.FND_INDEXES is referenced by following:

SchemaAPPS
SynonymFND_INDEXES