Oracle Database Discussions

Hi, all.

The database is 2 node RAC 10.2.0.2.0 on 32-bit windows
2003 EE SP1.

When does dba_objects.LAST_DDL_TIME change??
The object type is "TABLE".

1. Tuncate Table
2. Add Table Partition
3. Drop Table Partition
4. Add Column
5. Drop Column

select owner, object_name
from dba_objects
where created <> last_ddl_time
and object_type='TABLE';
----------------------------------------------------

The above SQL returns a lot of rows.( especially sys tables and sysman tables)
I did not issued "DDL command" to sysman tables and sys tables.

When does dba_objects.LAST_DDL_TIME change??
(Especially with regard to sysman and sys tables.)

Thanks and Regards.

Message was edited by:
user507290