Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!ucsd!nprdc!carroll From: carroll@nprdc.navy.mil (Larry Carroll) Newsgroups: comp.databases Subject: Re: also need help with ORACLE tables DBA_EXTENTS, etc. Message-ID: <10515@arctic.nprdc.arpa> Date: 8 Nov 90 20:53:50 GMT References: <11672@spool.cs.wisc.edu> Sender: news@nprdc.arpa Reply-To: carroll@nprdc.navy.mil (Larry Carroll) Organization: Navy Personnel R&D Center, San Diego Lines: 13 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