| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Counting number of rows
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
 |
 |