vsbabu.org

select 	a.OWNER,
	TABLESPACE_NAME,
	a.CLUSTER_NAME,
	TABLE_NAME,
	TAB_COLUMN_NAME,
	CLU_COLUMN_NAME
from 	dba_clusters a, dba_clu_columns b
where	a.CLUSTER_NAME = b.CLUSTER_NAME
order 	by a.OWNER,TABLESPACE_NAME,a.CLUSTER_NAME,TABLE_NAME

Jobs

DATABASE JOB NOTES:

select 	LOG_USER,
	SCHEMA_USER schema,
	JOB job#,
	INTERVAL,
	to_char(NEXT_DATE,'MM/DD/YYYY HH24:MI:SS') next_execution,
	BROKEN,
	substr(WHAT,1,100) what
from 	dba_jobs
order 	by LOG_USER

Links

DATABASE LINK NOTES:

select 	OWNER,
	DB_LINK,
	USERNAME,
	HOST,
	to_char(CREATED,'MM/DD/YYYY HH24:MI:SS') created
from  	dba_db_links
order	by OWNER,DB_LINK

Procs/Pkgs

DATABASE PROCEDURE/PACKAGE NOTES:

select	OWNER,
	NAME,
	TYPE
from  	dba_source
group	by OWNER,NAME,TYPE
order 	by OWNER,NAME,TYPE

Sequences

DATABASE SEQUENCE NOTES:

select 	SEQUENCE_OWNER,
	SEQUENCE_NAME,
	MIN_VALUE,
	MAX_VALUE,
	INCREMENT_BY,
	CYCLE_FLAG,
	ORDER_FLAG,
	CACHE_SIZE,
	LAST_NUMBER
from  	dba_sequences
where	SEQUENCE_OWNER not in ('SYS','SYSTEM')
order 	by SEQUENCE_OWNER,SEQUENCE_NAME

Snapshots

DATABASE SNAPSHOT NOTES:

select 
OWNER,
	NAME,
	TABLE_NAME,
	MASTER_VIEW,
	MASTER_OWNER,
	MASTER,
	MASTER_LINK,
	CAN_USE_LOG,
	UPDATABLE,
	LAST_REFRESH,
	ERROR,
	TYPE,
	NEXT,
	REFRESH_GROUP
from  	dba_snapshots
order 	by OWNER,NAME

Synonyms

DATABASE SYNONYM NOTES:

select	OWNER,
	SYNONYM_NAME,
	TABLE_OWNER,
	TABLE_NAME,
	DB_LINK
from  	dba_synonyms
where	owner not in ('SYS','SYSTEM','PUBLIC','DBSNMP')
order 	by OWNER,SYNONYM_NAME

Triggers

DATABASE TRIGGER NOTES:

select 	TABLE_OWNER,
	TABLE_NAME,
	TRIGGER_NAME,
	TRIGGER_TYPE,
	TRIGGERING_EVENT,
	STATUS
from 	dba_triggers
order 	by TABLE_NAME, TRIGGER_NAME

Views

DATABASE VIEW NOTES:

select 	OWNER,
	OBJECT_NAME,
	to_char(CREATED,'MM/DD/YYYY HH24:MI:SS') created,
	status
from  	dba_objects
where	OWNER not in ('SYS','SYSTEM')
and	OBJECT_TYPE='VIEW'
order	by OWNER,OBJECT_NAME