Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

synonyms cant be recompiled when the tables are dropped and recreated?

692864Apr 14 2009 — edited Apr 14 2009

hi

i have a synonym pointing to a table .

1)when i drop and recreate a table.............

isnt it enough to recompile the synonym? do i need to drop the synonym as well and recreate again?

2) when i add new columns to a table will the synonym also show up the new column?

thanks in advance
raj

This post has been answered by SomeoneElse on Apr 14 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2009

Added on Apr 14 2009

#general-database-discussions

14 comments

1,659 views