New objects created in last week

REM SCRIPT TO REPORT OBJECTS CREATED IN THE PAST WEEK
REM
REM Created on 06-May-2010
REM
SET PAGES 68 LINES 72
SET FEEDBACK OFF
SPOOL /u1/newobj.lst
TTITLE “OBJECTS CREATED IN THE DATABASE DURING PAST WEEK”
COL OBJECT_TYPE FORMAT A12
COL NAME        FORMAT A30
select object_type,owner ||’.’|| object_name as name,TO_CHAR(created, ‘mm-dd-yyy hh24:mi:ss’)
“CREATED ON”, status
from dba_objects
— enter the name of your schema eg: ABC, remove owner for all objects in all schemas
where created >= (sysdate – 7) and owner=’ABC’
order by object_type,name;
SPOOL OFF
TTITLE OFF
CLEAR COLUMNS
SET FEEDBACK ON

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s