Dear friend, my question is assume that we have created on table,on that table we are creating one view and one synonym know i have drop the table then status of view is invalid but status of synonym is not invalid pls give me the answer

Questions by basukolur014   answers by basukolur014

Showing Answers 1 - 6 of 6 Answers

raghgu

  • Nov 16th, 2006
 

hi friend, As per RDBMS rule we cannot have invalid synoym, but we can have a invalid view.

  Was this answer useful?  Yes

gangadharam.p

  • Jan 6th, 2007
 

hi,

  when u do so the view gets error and synonym becomes invalid. If u create a table again with same name but with different cols the synonym will work but view wont.bcz view is the stored select statement but synonym is the replica of the original.view depends on the colms of the table where as syn depends on the name of the table.

Thanks

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions