relative_fno vs file_id ??

[Edu]

Hello everybody.

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愀 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...

Eduardo Yanes.

[Jonathan Lewis]

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
tablespace.

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.

--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html

Edu <--eya...@mixmail.com> wrote in message
<3ADC52F7...@mixmail.com>...

>Hello everybody.
>
>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