Re: What is the Oracle equivalent to Sybase's sp_help?

Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<i02bg0thdruihqfhbv846vhpun6bgkouer_at_4ax.com>...
> On 26 Jul 2004 13:56:49 -0700, bridges.michael_at_worldnet.att.net
> (bridges) wrote:
>
> >Hello,
> >
> >I'm getting back into the Oracle world after a 10 year break and I
> >need some very basic information regarding the question in the subject
> >line.
> >
> >Just trying to get a feel for a database that is utilized by an
> >application that I support.
> >
> >Thanks.
>
> there is no such thing anymore, there are searchable docs at
> http://tahiti.oracle.com

Besides the searchable version of the documentation that Sybrand mentioned Oracle makes available information about every object in the database via the RDBMS Dictionary views. There is pretty much a veiw for every major object: DBA_TABLES, DBA_INDEXES, DBA_CONSTRAINTS, DBA_VIEWS, etc...

If you are returning to Oracle after a long absense then the following articles and the site they are hosted on may be of interest to you:

How do I find information about a database object: table, index, constraint, view, etc… in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html

How do I find out which users have the rights, or privileges, to access a given object ?
http://www.jlcomp.demon.co.uk/faq/privileges.html

HTH -- Mark D Powell -- Received on Tue Jul 27 2004 - 10:16:31 CDT