How
about :
select
owner, object_type, object_name from dba_objects where created = select
max(created) from dba_objects ;
That
ought to do it. Cheers :
Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel
Performance Engineering
Melbourne, 3000, VIC,
Australia
Please note 17 hour time
difference between Melbourne and CA
Only Robinson Crusoe had all his work done by
Friday
-----Original Message-----
From: Jalil Zabourdine [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 13 June 2002 3:03 AM
To: Multiple recipients of list ORACLE-L
Subject: 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 for Video Highlights of 2002 FIFA World Cup
