Read the Oracle Documentation or http://otn.oracle.com or
http://metalink.oracle.com
on what a RowID is. It is actually a composite of
File_Number_in_Database + Block_Number_in_File + Row_Number_within_Block.
Since a Table is like a heap rows may be inserted by Oracle in any of the
available
Title: RE: alter table rename error
HI ALL..
I HAVE PROBLEM
THE ROWID FIELD IS NOT SORTED IN MY DATABASE
WITH THE INSERTION DATA..
I INSERT THE TIME WITH EVERY RECORD
AND WHEN SELECT FROM THE TABLE WITH ORDER BY ROWID
I GET RANDOM TIMES IN TIME FIELD !!!
THAT HAPPEND WITH ME IN ONE TABLE
To: Multiple recipients of list ORACLE-L
Sent: Sunday, January 25, 2004 10:19
AM
Subject: ROWID PROBLEM
HI ALL..
I HAVE PROBLEM
THE ROWID FIELD IS NOT SORTED IN MY
DATABASE WITH THE INSERTION DATA..
I INSERT THE TIME WITH EVERY RECORD
AND WHEN SELECT FROM THE TABLE
You need to understand that Oracle inserts data where
space is available in a table, and dependent on previous
DML in a table, that could be almost anywhere.
If you want to see the data in timestamp order, then
order it by that column.
And please don't use ALL CAPS. It is difficult to read.
Title: RE: alter table rename error
Maybe the problem is with your capital
letters?!
Tanel.
- Original Message -
From:
Waleed
Haggagy
To: Multiple recipients of list ORACLE-L
Sent: Sunday, January 25, 2004 5:19
PM
Subject: ROWID PROBLEM
HI ALL..
I
PROBLEM
Maybe the problem is with your capital
letters?!
Tanel.
- Original Message -
From:
Waleed
Haggagy
To: Multiple recipients of list ORACLE-L
Sent: Sunday, January 25, 2004 5:19
PM
Subject: ROWID PROBLEM
HI ALL
