Modify Custom SQL DAC

2699805

Can we Add Alter Index Statement after the Create Index Statement in the Customsql.xml file? I tried but it's throwing errors.

<!--

This section will be used for creating ETL indexes for Oracle database

The variables will be substituted as follows:

%1 - UNIQUE

%2 - INDEX NAME

%3 - TABLE NAME

%4 - COLUMNS

WARNING: DO NOT MODIFY THE ORDER

-->

<SqlQuery name = "ETL_ORACLE_CREATE_INDEX">

CREATE %1 INDEX

        %2

ON

        %3

(

        %4

)

NOLOGGING

PARALLEL 16 TABLESPACE DW_FACT_INDX;

ALTER INDEX %2 PARALLEL;