Hiding hint in SQL from SQL Trace?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

enrikonewsgroups@earthlink.net - 29 Sep 2005 22:32 GMT

I have an ETL application that allows you to select a table delivery
method, one of which is APPEND. When I select this option and turn on
sql trace to watch the sql being generated there is no /*+ APPEND */
hint in the INSERT statement.
The application is written in C/C++.

Is it possible to hide a hint from sql trace?

Reply to this Message

William Robertson - 29 Sep 2005 23:47 GMT

enrikonewsgro...@earthlink.net wrote:

> I have an ETL application that allows you to select a table delivery
> method, one of which is APPEND. When I select this option and turn on
[quoted text clipped - 3 lines]
>
> Is it possible to hide a hint from sql trace?

Are you sure it is supposed to do an INSERT /*+ APPEND */?

Perhaps it just means APPEND as opposed to REPLACE, i.e. don't delete
the existing data before loading?

Reply to this Message