Re: how do I list tables in a database?

user_tables will only give you the tables in the database which your schema owns.

You're better off using

        select * from dba_tables

but make sure you have the correct "select" privileges first.

Cheers,

        Tim Received on Sun Jun 29 1997 - 00:00:00 CDT