Forum Stats

  • 3,741,181 Users
  • 2,248,384 Discussions


APPEND_VALUES hint in place of SYS_DL_CURSOR for OCI direct path load


While using OCI direct path load SYS_DL_CURSOR hint is implicitly getting added Is there a way to add APPEND_VALUES hint to for OCI direct path load? Note that we are not not passing the query in Direct Path context , we only pass the table name and the data stream.SYS_DL_CURSOR stream seems to be getting added by default. It has been found that SYS_DL_CURSOR takes up more space and less performant than APPEND_VALUES hint for direct path load.Please attach a sample program to  use APPEND_VALUES hint through OCI dpl LIBRARIES

Thanks & regards,


This discussion has been closed.