object_status.sql

oracle dba 常用的管理脚本, 覆盖日常的系统管理.

--* File Name    : Object_Status.sql
--* Author       : DR Timothy S Hall
--* Description  : Displays a list of objects and their status for the specific schema.
--* Requirements : Access to the ALL views.
--* Call Syntax  : @Object_Status (schema-name)
--* Last Modified: 15/07/2000
SET SERVEROUTPUT ON
SET PAGESIZE 1000
SET LINESIZE 255
SET FEEDBACK OFF
SET VERIFY OFF

SELECT Substr(object_name,1,30) object_name,
       object_type,
       status
FROM   all_objects
WHERE  owner = Upper('&&1');

PROMPT
SET FEEDBACK ON
SET PAGESIZE 18