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":
Copyright © 2007, 2015, Oracle and/or its affiliates. All rights reserved. Documentation build: 8.3.2015 14:40:38 [T1_1438638038000]