sql query help

From: Suhen Pather <pathers5_at_telkom.co.za>
Date: Wed, 28 Jun 2000 16:17:01 +0200
Message-Id: <10542.110658@fatcity.com>

Hi there Oracle Boffins

I am trying to create a script that can give me the following information.

All tables in the database (for specified users) together with the number = of rows in each table,size in bytes.
We are using the Rule based optimizer so I cannot use the row count from = the dictionary views.

I can achieve the row count from 1 query and the other information from = another query.

I can achieve all of the information but I cannot put this into one query.

I will have to cut and paste the information if I use 2 different queries = to get the desired information.
This is however not very efficient and could be a bit misleading.

Any ideas=20

TIA $uhen Received on Wed Jun 28 2000 - 09:17:01 CDT