Re: view schema.

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 16 May 2003 06:10:23 -0700
Message-ID: <2687bb95.0305160510.70ae5592@posting.google.com>

"Sergio" <smeligr_at_libero.it> wrote in message news:<ba21gg$oen4d$1_at_ID-186754.news.dfncis.de>...
> How I see the schema of a database? User's name is SYS.
> Thanks
> Sergio

Oracle provides hundreds of views into Database Information see the Oracle version# Reference manual

For a quick list of Oracle rdbms dictionary views such as dba_tables, dba_objects, etc... see

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

HTH -- Mark D Powell -- Received on Fri May 16 2003 - 08:10:23 CDT