Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table or view holding all database objects
Atte,
I do not know what language you are speaking. However, those serveral recognizable words did give me some hints. Thanks!
Frank
"Snake77" <rarauna_at_hotmail.com> wrote in message news:<rKjq8.7805$vf.100423_at_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 Wed Apr 03 2002 - 15:18:15 CST
![]() |
![]() |