Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Script for total number of rows

Script for total number of rows

From: Pinaki <bpinaki123_at_indiatimes.com>
Date: 17 Apr 2002 11:12:04 -0700
Message-ID: <96eccafc.0204171012.558f7ae0@posting.google.com>


Hi,

      I am a beginner in Oracle.I need a script that will show the total number of rows in all the tables in a specific schema.I can select the "NUM_ROWS" along with the table_names from user_tables but for that I have to run "Analyze table t compute statistics" for each table and I want to avoid doing that. Is there any way I can write a PL/SQL script that I can store in the database which will retrieve the information I want...

Thanks,
Pinaki Received on Wed Apr 17 2002 - 13:12:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US