Appendix D - Index Creation Script

The following script extracts the index DDL for CK tables and saves them in a script called create_​ck_​index.sql .

set pagesize 0
set linesize 3000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
spool alterindex.sql
SELECT 'ALTER INDEX '||u.index_name||' PARALLEL 32 NOLOGGING ;' FROM USER_INDEXES u where u.table_name like 'CK%';
spool off
@alterindex.sql
spool create_ck_index.sql
SELECT REPLACE ( DBMS_METADATA.GET_DDL('INDEX',u.index_name),'"','')||';' FROM USER_INDEXES u where u.table_name like 'CK%';
SELECT 'ALTER INDEX '||u.index_name||' NOPARALLEL LOGGING ;' FROM USER_INDEXES u where u.table_name like 'CK%';
spool off;
exit;

The create_​ck_​index.sql script can be used to recreate CX_​ID and CI_​ID indexes on the CK_​<table_​name> after all key assignment tiers have executed with MODE = "I":