Toad World® Forums

Force to create an explain plan even if a public QUEST_SL_EXPLAIN exist.

Hi

We are using the last version of sqlOptimiser for Oracle(8.5.0.2033)

Our database is 10g and the dba create a public QUEST_SL_EXPLAIN1 table.

The general option has been modified to force the use of this public table.

Unfortunately, when I run the sqloptimizer, the software is asking to create the table in my schema even ig the public table exist.

Note: I’m in a trial period. We have the previous version but currently, we are testing this tool for be part of our Oracle developer team.

Any clue of why sqloptimizer to force to have this table create on my schema?

Thank you

Message was edited by: RegisL

Please delete this thread since this is a copy from the one I made 2 minutes ago