How to Set Database Specific Initialization Options
Last updated
Was this helpful?
In certain configurations it may be necessary to run specific SQL statements or set database specific options each time a connection to a database is established.
The configuration file “Oracle.xml” contains parameters that control connections made to Oracle. The following configuration directives are supported:
InitSQL — specify a line of SQL that will be run each time a new connection to Oracle is established. There is no limit to the number of InitSQL elements.
The following Oracle.xml file will cause CopyStorm to run the command:
alter session set ‘_optimizer_rownum_pred_based_fkr’=FALSE
Oracle.xml:
<Oracle>
<InitSQL sql="alter session set "_optimizer_rownum_pred_based_fkr"=FALSE" />
</Oracle>Last updated
Was this helpful?
Was this helpful?