RE: Table or view holding all database objects

From: Snake77 <rarauna_at_hotmail.com>
Date: Tue, 2 Apr 2002 10:59:23 -0400
Message-ID: <rKjq8.7805$vf.100423@maule>

De forma separada

dba_constraints
dba_tables
dba_indexes
dba_views
dba_sequences
dba_synonyms

y otras dba_xxxxxx

con estas vistas puedes obtener lo que te entrega el sp_help, si quieres revisar el catalogo: dba_catalog

y para listar los objetos: dba_objects

atte
DBA ORACLE - SYBASE - SQL SERVER Sybrand Bakker <postbus_at_sybrandb.demon.nl> escribió en el mensaje de noticias 0afhaug543ukqvt4142ee08apitnvp60ch_at_4ax.com...
> On 1 Apr 2002 11:28:14 -0800, frankfz_at_yahoo.com (Frank) 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.
> >
> >Thank you for your reponse!
>
> dba_objects
>
> Please forget everything you know about sqlserver, and stop trying to
> find the exact equivalent. You will learn Oracle faster.
> The definition of sysobjects might be well different from dba_objects
> (dba_objects only lists the properties common to all objects, it
> definitely doesn't list all properties)
> Evidently also the contents of the data dictionary are thorougly
> documented in the manuals.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Apr 02 2002 - 08:59:23 CST