Unqualified Objects

Document ID : KB000013031
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

After executing a future explain for a package that had unqualified tables, the target subsystem was different that the source. Plan Analyzer was able to determine the correct qualifier to use withour user specifying it in the SQL qualifier panel. How did PPA do that?             

Answer:

Explain will use the qualifier from SYSPACKAGE or SYSPLAN for catalog SQL  Unless the user has requested through explain option SQL qualifier override that another qualifier be used instead for all unqualified objects.