beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung)) (11/08/90)
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?
carroll@nprdc.navy.mil (Larry Carroll) (11/09/90)
The tables you are referring to, dba_extents, dba_tables, etc., are owned by the sys account. Therefore you need to fully qualify your select statement. Here is an example: select * from sys.dba_extents; Hope this helps, Larry Carroll carroll@nprdc.navy.mil ...}ucsd!nprdc!carroll
broy@vaxa.weeg.uiowa.edu (Barbara Roy) (11/13/90)
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.