Re: using dbv to check a segment

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.

Good Luck

Richard
"Lothar Armbruester" <lothar.armbruester_at_t-online.de> wrote in message news:PM0003A9342CCD5761_at_hades.none.local...
> Hello out there,
>
> I have some problems checking a database segment with dbv on Oracle
> 9.0.1.3 on W2k.
>
> First, the docs say I should use
>
> dbv userid=user/password segment_id=tsn.relfile.block
>
> Since the docs also say dbv has to connect as sysdba I tried connecting
> as sys but I cannot say
> dbv userid=sys/syspwd ...
>
> Then I tried
>
> dbv userid="sys/syspwd as sysdba" ...
>
> but that also failed.
> Now what ist the correct syntax to call dbv with sys as sysdba?
>
> Second, I lack some understanding of the segment_id.
>
> To get relfile and block I say
>
> select haeder_file,haeder_block from dba_segments where
> segment_name='MY_TABLE';
>
> But what does tsn mean? I guessed "table segment name", is that correct?
>
> Can someone point me to some docs where this is explained?
>
> I searched the docs for tsn but just found the small description of dbv.
> Are there some examples getting the segment_id for a given table/index?
>
> Many thanks in advance,
> 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 - 06:23:35 CDT