-
Title
Circular references when trying to generate a schema script in TOAD for Oracle -
Description
When using the "Generate Schema Script" option in TOAD for Oracle against the Spotlight on Oracle schema the following comments are appended to the end of the generated script:
-- Note:
-- The following objects may not be sorted properly in the script due to cirular references
--
-- QUEST_PPCM_COLLECTOR_PM (Package)
-- QUEST_PPCM_COLLECTOR (Package)
-- QUEST_PPCM_COLLECTOR_PM (Package Body)
-- QUEST_PPCM_COLLECTOR (Package Body)
-
Cause
Caused by object A referencing B, possibly referencing others, and the chain of dependencies works its way back to object A.
-
Resolution
WORKAROUND:
This is not an error, just a notification that you might have to recompile some objects after you have finished running the script.
-
Additional Information
This explanation was also posted on the Toad Forum here:
http://toadfororacle.com/thread.jspa?threadID=29439&tstart=-13&messageID=109422