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)
Caused by object A referencing B, possibly referencing others, and the chain of dependencies works its way back to object A.
WORKAROUND:
This is not an error, just a notification that you might have to recompile some objects after you have finished running the script.
This explanation was also posted on the Toad Forum here:
http://toadfororacle.com/thread.jspa?threadID=29439&tstart=-13&messageID=109422
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center