Message from discussion relative_fno vs file_id ??
From: "Jonathan Lewis" <jonat...@jlcomp.demon.co.uk>
Subject: Re: relative_fno vs file_id ??
Date: Tue, 17 Apr 2001 15:42:16 +0100
X-Trace: news.demon.co.uk 987518327 nnrp-07:28121 NO-IDENT jlcomp.demon.co.uk:22.214.171.124
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
file_id is the absolute file number within
the control file structure
relative_fno is a file number within tablespace.
It is slightly misleading to call it the 'relative file
number' as Oracle has done, as this suggests
that just about every relative file number should
be 1 as the first file in the tablespace. In fact
the number simply has to be unique within a
To maintain backwards compatibility with 7,
Oracle has arranged the code for handling
relative file numbers so that relative file number
= absolute file number for the first 1022 (-ish) files
in the database. However there is an event
(10120 I think) that you can set at the database
level if you want to experiment with relative file
numbers that do not match absolute file numbers.
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Edu <--eya...@mixmail.com> wrote in message
>Whats's the difference between relative_fno and file_id ?
>We are looking for any instance with different values into this two
>columns but there´s no one... no one with differences between
>dba_data_files and dba_temp_files ( and there are temporary, permanent
>and locally managed tablespaces... with more than one datafile... )
>Any help please ...
>Thanks in advance...