This script will do a fast search on all database objects. @obj fnd will find all fnd% database objects. Also shows if object is invalid. This script is essential for finding objects in the 340.000 objects in an Oracle Applications database. Use copy/paste for execution of the describe.     SQL> @obj fnd_glo OBJECT_NAME                              OBJECT_TYPE         ---------------------------------------- -------------------- desc APPS.FND_GLOBAL                     — PACKAGE        desc APPS.FND_GLOBAL                     — PACKAGE BODY   desc APPS_MRC.FND_GLOBAL                 — SYNONYM        SQL>   Syntax: @obj <partial object name>     @obj (0 downloads)

Leave a Reply