Is a Synonym Valid after "Altering" a table 2

[sa0309]

I'm running Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.

I want to ALTER a table ( add a column ). Will this cause the synonym to become invalid?

Thank you.

 

[SantaMufasa]

SA,

As our Tek-Tips colleagues can attest, the motto I live by is "One test is worth 100 expert opinions." This is why I usually post responses here that are real, live tests for a question.

Here is my test for your scenario:

12:57:57 SQL> create synonym y for summit.x;

Synonym created.

(re-connect as user SUMMIT)

12:59:43 SQL> alter table x add (new_col number);

Table altered.

(re-connect as synonym-owning user)

select object_name,object_type,status from user_objects where object_name = 'Y';

OBJECT_NAME     OBJECT_TYPE         STATUS
--------------- ------------------- -------
Y               SYNONYM             VALID

1 row selected.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.

 

[johnherman]

As usual, Santa Dave has provided the very best guidance. *testing* It's been awhile since I've given a star to Mufasa, so have one, please.

====================================
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw

 

[sa0309]

Agree with u Johnherman.

Question answered.

Thank you!

 

[SantaMufasa]

As they say in England, "Ta, Mates!"

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.