Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using dbv to check a segment
Richard Foote wrote:
> Hi Lothar,
>
> Don't feel too bad about asking this question. The documentation for
> this is
> utterly atrocious (and that's putting it mildly).
>
> A few issues:
>
> 1) You can't connect as sys (or I don't know of a way to do so). You
> need to
> connect in as some other database user that has been granted sysdba
> privileges
>
> 2) The segment_id is made of the following components, all of which
> you can
> determine from DBA_SEGMENTS: RELATIVE_FNO.HEADER_FILE.HEADER_BLOCK (or
> tsn.segfile.segblock as the doco so clearly describes)
>
> So something such as DBV userid=bowie/bowiepw segment_id=7.7.339 will
> do the
> trick.
>
[...]
Thanks Richard,
I will give it a try.
Regards,
Lothar
-- Lothar Armbrüster | la_at_oktagramm.de Hauptstr. 26 | la_at_heptagramm.de D-65346 Eltville | lothar.armbruester_at_t-online.deReceived on Wed Aug 28 2002 - 11:24:54 CDT