select owner,
object_type,
object_name,
to_char(created,'yyyy/mm/dd') created,
to_char(last_ddl_time,'yyyy/mm/dd') last_ddl_time,
status
from sys.dba_objects
where owner like upper('&ow%')
and object_type like upper('&ot%')
and object_name like upper('&on%')
and status like upper('&st%')
order by last_ddl_time desc,1,2,3
/
-----Message d'origine-----
De: Jalil Zabourdine [mailto:[EMAIL PROTECTED]]
Date: jeudi 13 juin 2002 12:03
�: Multiple recipients of list ORACLE-L
Objet: How to find out the latest object created in DB?
Hi DBAs,
Does anyone has a script to find out the latest object created in database?
Thanks in advance,
Regards,
-Jalil
_____
Do You Yahoo!?
Sign-up
<http://rd.yahoo.com/welcome/*http://fifaworldcup.yahoo.com/fc/en/spl> for
Video Highlights of 2002 FIFA World Cup
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
