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, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]