RE: Unexpected result from ALL_TABLES

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <kinzlaw@xxxxxxxxx>, Michael Garfield Sørensen <mgs@xxxxxxxx>
  • Date: Fri, 10 Aug 2007 07:51:26 -0400

Don't take it too hard.  Acknowledge the error and move on.  We all put a foot 
in the mouth once in a while...J

 

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxxxxx> 
www.proquest.com <http://www.proquest.com> 
www.csa.com <http://www.csa.com> 

ProQuest...Start here. 

 

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of kinzlaw cgm
Sent: Friday, August 10, 2007 7:03 AM
To: Michael Garfield Sørensen
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Unexpected result from ALL_TABLES

 

Hi Michael!
Sorry and yes, the one who needs to read the Docs is me.
As I have said, I'm quite new to Oracle. I just happened to read some
stuff on ALL_TABLES and  USER_TABLES(and other things about
ALL_* and USER_* views), but I have memorized it exactly. When 
seeing Dennis' situation, in my opinion I "figured out" that ALL_*
views is about all the things on the system "with confident" and
haven't given a try.
After reading your mail, I experimented with a simple case, which 
told me that ALL_TABLES are the tables with which the user has
access to. I apologize for negligence of mine and saying wrong
thing on the list.

-- 
Learning Oracle 
http://kinzlaw.wordpress.com 

Other related posts: