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: Urgent help needed!

Re: Urgent help needed!

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 13 Sep 2006 20:19:29 -0700
Message-ID: <1158203968.960957.219080@i3g2000cwc.googlegroups.com>

  1. You will be able to on the USER_SEGMENTS view (to see your tables and indexes) or 2. on the USER_ or ALL_TABLES and ALL_INDEXES just remember to Select owner first and group by owner if you use the ALL_ views, as it will include objects from SYS, SYSTEM ... if you have been granted some access to those objects.

hth. Received on Wed Sep 13 2006 - 22:19:29 CDT

Original text of this message

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