The PRINT_INDEX_DDL is used to generate the DDL for a single index or all the indexes for the specified table.
| Parameter | Description | |
|---|---|---|
| SCHEMA_NAME | Type: | INPUT |
| Datatype: | VARCHAR2(128) | |
| Default Value: | INUSER | |
| Description | The schema name that owns the table. | |
| TABLE_NAME | Type: | INPUT |
| Datatype: | VARCHAR2(128) | |
| Default Value: | None | |
| Description | The table name for which to generate the index DDL. | |
| INDEX_NAME | Type: | INPUT |
| Datatype: | VARCHAR2(128) | |
| Default Value: | None | |
| Description | The index name for which to generate the DDL. | |
Exceptions
Examples
SET SERVEROUTPUT ON;
EXEC IN_DB_UTIL.PRINT_INDEX_DDL('INUSER', 'IN_DOC');
EXEC IN_DB_UTIL.PRINT_INDEX_DDL('INUSER', 'IN_DOC', 'DOC_IDX2');
Example Output
CREATE UNIQUE INDEX "INUSER"."DOC_IDX2" ON "INUSER"."IN_DOC"
(
NLSSORT("DRAWER_ID", 'nls_sort=''BINARY_CI'''),
NLSSORT("FOLDER", 'nls_sort=''BINARY_CI'''),
NLSSORT("TAB", 'nls_sort=''BINARY_CI'''),
NLSSORT("F3", 'nls_sort=''BINARY_CI'''),
NLSSORT("F4", 'nls_sort=''BINARY_CI'''),
NLSSORT("F5", 'nls_sort=''BINARY_CI'''),
NLSSORT("DOC_TYPE_ID", 'nls_sort=''BINARY_CI'''),
NLSSORT("LEGACY_UNIQUENESS", 'nls_sort=''BINARY_CI''')
)
PCTFREE 10
INITRANS 2
MAXTRANS 255
COMPUTE STATISTICS
STORAGE
(
INITIAL 65536
NEXT 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACH DEFAULT
)
TABLESPACE "INDX";