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
you need to read the documentation. Oracle is
supposed to workt his way.
otn.oracle.com
start with the concepts document. Skip the stuff on
java, xml, etc... read the first 10-12 chapters.
- Original Message -
From:
Waleed
Haggagy
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
All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED]Sent: Sunday, January 25, 2004 5:55
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
ROWID
