Saturday, February 21, 2015

Details of all user tables

SELECT TABLE_NAME, TABLESPACE_NAME, LOGGING, NUM_ROWS, LAST_ANALYZED, PARTITIONED FROM USER_TABLES ORDER BY LAST_ANALYZED DESC

No comments:

Post a Comment