View Single Post

   
  #3 (permalink)  
Old 03-06-2008, 03:04 PM
rajigopal@gmail.com
 
Posts: n/a
Default Re: Can we rely on object_id always increasing?

On Mar 4, 11:33*am, czytacz <redak...@dupa.gazeta.pl> wrote:
> no,
> if you:
>
> 1) create table A
> 2) create view V basis on A
> 3) drop table A
> 4) create table A (new 'A', the same name as A)
>
> the new A table will have bigger objectID than view V


What you're saying then is that objects created will have an ever-
increasing object_id, right? Meaning, ordering by create_date is the
same as ordering by object_id....correct?

Thanks!
Reply With Quote