Is there a way I can tell when a sequence was created? I looked in user_objects but that doesn't include info about sequences. Thx for the help.
Printable View
Is there a way I can tell when a sequence was created? I looked in user_objects but that doesn't include info about sequences. Thx for the help.
SQL> create sequence sq;
SQL> select object_name, created from user_objects
where object_type = 'SEQUENCE';
OBJECT_NAME
------------
CREATED
---------
SQ
11-APR-01
make sure you are the owner when querying user_object, or look in dba_objects. it will have a CREATED field with this info.
d.
thx - that did the trick!