Another problem with relying on last_ddl_time is that not all DDLs update that, such as alter table shrink space, alter trigger compile. See http://yong321.freeshell.org/oranotes/DDLsNotUpdatingLast_ddl_time.txt Yong Huang -- //www.freelists.org/webpage/oracle-l
