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

Hi,

Would you please run the following SQL “select owner, object_name, object_type from all_objects where object_name like ‘QUEST_SL_%’” in your database 10g and then give me the result?

Thanks,
Cliff

Hi cchan

Here the result

OWNER OBJECT_NAME OBJECT_TYPE


PUBLIC QUEST_SL_EXPLAIN1 SYNONYM
SYSTEM QUEST_SL_TEMP_EXPLAIN1 TABLE
OPS$SUPERMAN QUEST_SL_EXPLAIN1 TABLE

Message was edited by: RegisL

Hi,

Please try explain plan in SQL Plus with the same connection identities and see if you are able to get plan. If not success, try grant Select On the table at the back of the synonym ‘Quest_SL_Explain1’ and get plan again.

Thanks,
Cliff