Re: Get all user tables that current user has access to and that have data

all_tables would be the one. Look up the num_rows column to see if there is any data in the table. But, the tables you look at must have been analyzed for the number in num_rows to be accurate.

• Jusung Yang

qwert12345_at_boxfrog.com (Doug Baroter) wrote in message news:<fc254714.0301061440.516232c8_at_posting.google.com>...
> Hi,
>
> With Oracle9i, how to achieve the above? of 'all_tables' and
> 'all_objects', which one should I go after? and how to include the
> requirement that table must have user data. Thanks.
Received on Tue Jan 07 2003 - 19:06:17 CET