You could do this: SELECT owner, table_name, num_rows, last_analyzed FROM dba_tables WHERE owner = '<table_owner>' AND table_name = '<table_name>' assuming your USER has access to the DBA_TABLES view (i.e., has select_catalog_role). Also, it will only be as accurate as your last_analyzed time. Best regards, David B. Wagoner Database Administrator ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------