ROWID_TO_ABSOLUTE_FNO Function

This function extracts the absolute file number from a ROWID, where the file number is absolute for a row in a given schema and table. The schema name and the name of the schema object (such as a table name) are provided as IN parameters for this function.

Syntax

DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO (
   row_id      IN ROWID,
   schema_name IN VARCHAR2,
   object_name IN VARCHAR2)
  RETURN NUMBER;

Pragmas

   pragma RESTRICT_REFERENCES(rowid_to_absolute_fno,WNDS,WNPS,RNPS);

Parameters

Table 57-9 ROWID_TO_ABSOLUTE_FNO Function Parameters

Parameter	Description
row_id	ROWID to be interpreted.
schema_name	Name of the schema which contains the table.
object_name	Table name.

Example

DECLARE

abs_fno        INTEGER;
rowid_val      CHAR(18);
object_name    VARCHAR2(20) := 'EMP';

BEGIN

SELECT ROWID INTO rowid_val 
FROM emp
WHERE empno = 9999;
 abs_fno := dbms_rowid.rowid_to_absolute_fno(
 rowid_val, 'SCOTT', object_name);

Note: For partitioned objects, the name must be a table name, not a partition or a sub/partition name.