Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!uunet!ns-mx!vaxa.weeg.uiowa.edu!broy
From: broy@vaxa.weeg.uiowa.edu (Barbara Roy)
Newsgroups: comp.databases
Subject: Re: also need help with ORACLE tables DBA_EXTENTS, etc.
Message-ID: <3179@ns-mx.uiowa.edu>
Date: 13 Nov 90 15:02:07 GMT
References: <11672@spool.cs.wisc.edu>
Sender: news@ns-mx.uiowa.edu
Reply-To: broy@vaxa.weeg.uiowa.edu
Organization: Weeg Computing Center, University of Iowa, Iowa City, IA, USA
Lines: 13
News-Software: VAX/VMS VNEWS 1.3-4

In article <11672@spool.cs.wisc.edu>, beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung)) writes...
>Oracle v. 6.0 dba guide lists system tables such as DBA_EXTENTS, DBA_TABLES.
>WHen I try to get a description or select from them sqlplus claims that
>they don't exist. I have dba priveledges. Logging on as system/**** still
>doesn't produce these tables. Do they have some different name?

These tables are owned by SYS under version 6. Access them as SYS.DBA_EXTENTS 
etc.

Barbara Roy, Weeg Computing Center, University of Iowa, Iowa City, IA. 52242
Phone: 319-335-5506  
Internet: broy@vaxa.weeg.uiowa.edu     Bitnet: broyva@uiamvs
Disclaimer: My opinions are solely my own and may change daily.