Re: ALL_OBJECTS TIMESTAMP column
Date: Wed, 16 Dec 2009 11:41:56 -0800
Message-ID: <b7fb88be0912161141p178b9585n56327d5a833e72e2_at_mail.gmail.com>
Looks like it could change if the synonym is redefined, though interestingly enough, not if it's redefined to point to the same target, or if the synonym becomes invalid. It does, however change once the synonym becomes valid again:
SQL> create synonym rogets for dba_objects;
Synonym created.
SQL> select object_name
2 , timestamp
3 from user_objects
4 where object_name = 'ROGETS';
ROGETS
2009-12-16:11:14:48
SQL> create or replace synonym rogets for dba_objects;
Synonym created.
SQL> select object_name
2 , timestamp
3 from user_objects
4 where object_name = 'ROGETS';
ROGETS
2009-12-16:11:14:48
SQL> create table foo (bar integer);
Table created.
SQL> create or replace synonym rogets for foo;
Synonym created.
SQL> select object_name
2 , timestamp
3 from user_objects
4 where object_name = 'ROGETS';
ROGETS
2009-12-16:11:19:48
SQL> drop table foo;
Table dropped.
SQL> select object_name
2 , status 3 , timestamp
4 from user_objects
5 where object_name = 'ROGETS';
ROGETS
INVALID 2009-12-16:11:19:48
SQL> create table foo (baz varchar2(30));
Table created.
SQL> select object_name
2 , status 3 , timestamp
4 from user_objects
5 where object_name = 'ROGETS';
ROGETS
INVALID 2009-12-16:11:19:48
SQL> select count(*) from rogets;
0
SQL> select object_name
2 , status 3 , timestamp
4 from user_objects
5 where object_name = 'ROGETS';
ROGETS
VALID 2009-12-16:11:36:42
-- Regards, John P. On Wed, Dec 16, 2009 at 10:53 AM, <lyallbarbour_at_sanfranmail.com> wrote:Received on Wed Dec 16 2009 - 13:41:56 CST
> i don't have docs to back this up, but off the top of my head, it changes
> if the synonym becomes invalid i would say.
> Lyall
>
>
> -----Original Message-----
> From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
> To: oracle-l_at_freelists.org
> Sent: Wed, Dec 16, 2009 1:36 pm
> Subject: ALL_OBJECTS TIMESTAMP column
>
> I've searched MOS and Google for this and not come up with much. Oracle
> 10.2.0.4.
> What is the meaning of USER_OBJECTS.TIMESTAMP for a private synonym? What
> might cause it to change?
> *Paul Baumgartel*
> *CREDIT SUISSE*
> Information Technology
> Prime Services Databases Americas
> One Madison Avenue
> New York, NY 10010
> USA
> Phone 212.538.1143
> paul.baumgartel_at_credit-suisse.com
> ***www.credit-suisse.com*
>
>
>
> ==============================================================================
> Please access the attached hyperlink for an important electronic
> communications disclaimer:
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
>
> ==============================================================================
>
>
-- http://www.freelists.org/webpage/oracle-l