写错了LASE_..应为LAST_..
SELECT LAST_DDL_TIME FROM ALL_OBJECTS WHERE OWNER='USERNAME' AND OBJECT_TYPE = 'TABLE' AND OBJECT_NAME= 'EVT_OPERATORS';
然后
SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER='USERNAME' AND OBJECT_TYPE = 'TABLE' AND
LAST_DDL_TIME > TO_DATE('99-03-01','YY-MM-DD');
先取出
SELECT LASE_DDL_TIME FROM ALL_OBJECTS WHERE OWNER='USERNAME' AND OBJECT_TYPE = 'TABLE' AND OBJECT_NAME= 'EVT_OPERATORS';
然后
SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER='USERNAME' AND OBJECT_TYPE = 'TABLE' AND
LASE_DDL_TIME > TO_DATE('99-03-01','YY-MM-DD');
只要你没有对这些系统表进行改动,应该没问题,试试吧