Sunday, September 12, 2010

How to find out table partition creation date?

select owner,object_name,subobject_name,to_char(created,'DD.MM.YYYY HH24:MI:SS') from dba_objects where object_type='TABLE PARTITION' and trunc(created) = trunc(sysdate);

No comments:

Post a Comment