Hi, i had to rename a table temporarily and i then renamed it back. There were many views against this table( including views on views based on this table)
all of which are now showing as invalid. If i do a select statement against a view it returns the correct data and the status of the view changes back to valid.
Is there any harm in leaving all of the views as invalid in the assumption that whenever one is queried it will become valid again?
Many thanks