Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: using dbv to check a segment
Hi Lothar,
Spot on !!
I actually used this many months ago while I was still at Oracle and I remember scratching my head at the time in that the required values were not obvious (to a slow wit like me anyway).
Anyway, after a few goes, I got it to work using the relative file number and it picked up all the segments I was after. However, I realise now that by good luck rather than good anything else, both the tablespace number and relative file numbers were quite likely the same !!
Ignorance is bliss ;)
Richard
"Lothar Armbrüster" <larmbruester_at_vertriebsunion.de> wrote in message
news:8cf2adac.0208290217.7db5e6f9_at_posting.google.com...
> "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 - 20:57:49 CDT