Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Query on Structure of Database

Re: Query on Structure of Database

From: <jedi_at_dementia.mishnet>
Date: Thu, 22 Jul 1999 09:36:09 -0700
Message-ID: <slrn7pei3p.gqk.jedi@dementia.mishnet>


On Wed, 21 Jul 1999 09:15:05 +0200, Raoul <rherborg_at_yahoo.de> wrote:
>Hello everybody
>
>Are there any SQL commands (or other ways) to get information on the
>structure of a database?
>
>I would like to get information on things like "which tables are within
>a certain tablespace", "what constraints do exist for a field within a
>table", ...
>
>Probably something pretty simple, but I just can't find any starting
>point to search for all this. Any little hint would be welcome.

	I'm not sure about the version 8 manuals. However, these views are
	documented in Chapter 2 of the v7 Server Reference Manual. You can
	also stumble through them using _Schema Manager_ (user sys) or in
	an sqlplus session (as user sys) by looking through user_views.

>
>Thanks a lot
>
> Raoul-Thomas Herborg

--

It helps the car, in terms of end user complexity and engineering, that a car is not expected to suddenly become wood chipper at some |||

arbitrary point as it's rolling down the road.                       / | \
						                       
			Seeking sane PPP Docs? Try http://penguin.lvcm.com

Received on Thu Jul 22 1999 - 11:36:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US