SELECT OWNER , OBJECT_NAME , SUBOBJECT_NAME , OBJECT_TYPE , CREATED , LAST_DDL_TIME , TIMESTAMP , STATUS , TEMPORARY
FROM ALL_OBJECTS
WHERE OBJECT_TYPE = 'TABLE'
ORDER BY CREATED DESC ;
SELECT OWNER , OBJECT_NAME , SUBOBJECT_NAME , OBJECT_TYPE , CREATED , LAST_DDL_TIME , TIMESTAMP , STATUS , TEMPORARY
FROM ALL_OBJECTS
WHERE OBJECT_TYPE = 'TABLE'
ORDER BY CREATED DESC ;