RE: ROWID PROBLEM

[Jamadagni, Rajendra]

Title: RE: alter table rename error

Yeah ... in 9i, rowid's in capital letters don't work correctly, they only work on Windows ... which is case insensitive.   8:) Raj -------------------------------------------------------------------------------- Rajendra dot Jamadagni at nospamespn dot com 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 PM To: Multiple recipients of list ORACLE-L Subject: Re: ROWID 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..   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 ONLY !!!!       WALEED HAGGAGY ************************************************************************************** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **************************************************************************************4