APT_ORACLE_LOAD_OPTIONS Issue
Posted: Wed Sep 20, 2017 5:46 am
Hello,
I am trying to bulk load the data, i also overrided the APT_ORACLE_LOAD_OPTIONS with "OPTIONS(DIRECT=TRUE,PARALLEL=TRUE)", however its not working, when i check the explain plan in Oracle(target db), its always going to Conventional Path though i set Direct Path as True. Did anyone face this? Please let me know.
Thanks for your help in advance.
Thanks & Regards
Koti
I am trying to bulk load the data, i also overrided the APT_ORACLE_LOAD_OPTIONS with "OPTIONS(DIRECT=TRUE,PARALLEL=TRUE)", however its not working, when i check the explain plan in Oracle(target db), its always going to Conventional Path though i set Direct Path as True. Did anyone face this? Please let me know.
Thanks for your help in advance.
Thanks & Regards
Koti