!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! This note is superceded by ../computer/UncommonSenseAboutCommonObjects.doc !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! A DDL is a SQL that modifies data dictionary and commits your transaction implicitly [note] But not all DDLs update xxx_objects.last_ddl_time. In Oracle 10.2.0.4, they are: * alter index shrink space (but it will update the table's last_ddl_time) * alter table shrink space * alter index coalesce * alter trigger compile * analyze * dbms_stats.gather_table_stats (consider it as DDL since it implicitly commits and populates data dictionary) By the way, these DDLs also don't seem to invalidate cursors that reference the table, except for analyze and dbms_stats.gather_table_stats (the latter can be controlled by no_invalidate). _______________ note: "Implicit" means it's not necessarily associated with 'user commits' statistic. For a list of DDLs that do and do not increment that statistic, see Appendix of ./RollbackCommitStats.txt.