Dictionary objects


Find the dictionary table

set linesize 200
set verify off
set pagesize 9999

COLUMN table_name      	FORMAT a30            HEADING 'Table name'
COLUMN Comments   		FORMAT a90            HEADING 'Comments'

select table_name, comments 
	from dictionary 
	where table_name like upper('%&TABLE_TO_FIND%')
order by table_name
/

Fixed tables

set linesize 200
set verify off
set pagesize 9999
select name, type from v$fixed_table 
	where name like upper('%&TABLE_TO_FIND%')
	order by name
/