Re: Table or view holding all database objects

On 1 Apr 2002, frankfz_at_yahoo.com wrote:
> Does Oracle Database has a system table or view, in which lists the
> properties of all objects regardless of owner, schema? I’m
> trying to find a similar system table, which is called sysobjects in
> MSSQL, in Oracle database.

What does sysobjects return you?

dba_objects will give you lots of information, and you can choose to ask for the owner or not.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.