I have something that pulls out all the foreign key references (without indexes, but just change the code to get them all) for postgresql at
http://xarg.net/download/fk.tcl.txt and there is corresponding query for oracle at
http://osi.oracle.com/~tkyte/unindex/index.html
that will do it for oracle. It would be great if we
could get some of this stuff cleaned up.
