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.