Oracle Connector Issue on Rebuild Indexes

[eph]

Hi all,

I'm running an Oracle Connector stage with bulk load to a table passed in a parameter as following: #SCHEMA#.#TABLE#.

All inserts and selects made on the database use that schema as part of the sql instruction, but the rebuild index is not using it.

Oracle traces are as follow:

Code: Select all

bpopsgl1_ora_987304.trc:INSERT /*+ SYS_DL_CURSOR */ INTO SYSADM.PS_E1_SUBSTI_TAOD .......
bpopsgl1_ora_1671180.trc:ALTER INDEX PS_E1_SUBSTI_TAOD REBUILD PARALLEL 2

Is there a way to tell the connector about using this very schema? Or Should I use a specific PL/SQL in a after SQL statement (I need to rebuild all indexes on the table)?

Thanks for any input,
Eric