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" <richard.foote_at_bigpond.com> wrote in message news:<yg2b9.17229$g9.53386_at_newsfeeds.bigpond.com>...
[...]
>
> 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.
>
Hello Richard,
I just tried your suggestion and found out that RELATIVE_FNO is not
the right thing. It has to be TABLESPACE_ID which is found in
SYS_DBA_SEGS.
So tsn seems to mean tablespace number.
Regards,
Lothar
Received on Thu Aug 29 2002 - 05:17:01 CDT