Re: Find file# from block DBA in its integer 48-bit form

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 23 Dec 2005 09:23:03 -0800
Message-ID: <1135358565.680037@jetspin.drizzle.com>

Spendius wrote:
> Hi,
> How can I deduce the file number of the following block address:
> 306184587 ? Where/how is the file number stored ?
>
> Thanks a lot !
> Regards,
> Spendius

Demos of the functionality in the DBMS_ROWID and DBMS_UTILITY packages can be found in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri Dec 23 2005 - 11:23:03 CST

This message: [ Message body ]
Next message: DA Morgan: "Re: SQL*Plus 'copy' cmd: deal with rollbacks ?"
Previous message: DA Morgan: "Re: Diff between utlxplp.sql and utlxpls.sql ?"
In reply to: Spendius: "Find file# from block DBA in its integer 48-bit form"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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