Table_View_Info

Version 4
    Share:|

    In interactions with customers it is often noted that getting table/view information is a back and forth operation between Support/PE and the customer.

     

    The accompanying zip file contains SQL scripts, written for the Oracle database, will help gather information about a table or view in one fell swoop so to speak.

     

    UPDATE

    The Table_Info script has been updated to now show Function-Based Normal indexes too.

     

    TABLE INFO

    "table_info_wrapper.sql" can be run as SYS or ARADMIN (or the Remedy schema owner as the case may be).

                    * * * * "table_info_wrapper.sql" accepts the table name to be queried and calls 2 other scripts, one of which gathers index statistics.

    VIEW INFO

    "view_info_wrapper.sql" needs to be run as SYS. 

                     * * * * "view_info_wrapper.sql" also accepts the view name to be queried and gets its DDL information from dbms_metadata.get_ddl.