Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: using dbv to check a segment

Re: using dbv to check a segment

From: Lothar Armbruester <lothar.armbruester_at_t-online.de>
Date: Wed, 28 Aug 2002 18:24:54 +0200
Message-ID: <PM0003A9480F939DCA@hades.none.local>


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.de
Received on Wed Aug 28 2002 - 11:24:54 CDT

Original text of this message

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