segment_write_time

Hi,

on 12 c , I have :

SQL> select object_name, segment_write_time

  2  from dba_heat_map_segment

  3  where object_name='EMPLOYEE';

OBJECT_NAME               SEGMENT_W

------------------------- ---------

EMPLOYEE                  17-JUL-14

and then I run :

sqlplus / as sysdba

alter session set nls_date_format='dd-mon-yy hh:mi:ss';

declare
   v_obj# number;
   v_dataobj# number;
   v_ts#      number;
begin
    select object_id, data_object_id into v_obj#, v_dataobj#
    from all_objects
    where object_name = 'EMPLOYEE'
      and owner = 'SCOTT';
    select ts# into v_ts#
    from sys.ts$ a,
    dba_segments b
    where  a.name = b.tablespace_name
      and  b.segment_name = 'EMPLOYEE';