Toad World® Forums

Message about 'circular references' when doing Create Script


#1

when I reverse engiveer and create DDL i’m getting message “This schema contains either circular references or feferences to invalid objects which prevents TOAD from sorting the last x items…”
the only option is to click OK and the script but not in a sorted order.

Has anybody experience this message and what might be causing it?

P.S i have no invalid objects in this schema

TOAD_MESSAGE.doc (30.5 KB)


#2

It’s caused by object A referencing B, possibly referencing others, and
the chain of dependencies works its way back to Object A. It’s not an
error – just a notification that you might have to recompile some objects
after you are done running the script.