This content has been marked as final. Show 3 replies
Also if wished to preserve the table would there be any implications of dropping i e.g drop preserve table.
What table? The MVIEW table itself? No - you can preserve it.
But then a new table will be created when you create the new MVIEW. You could modify the current MVIEW table and then create a new MVIEW using the PREBUILT TABLE clause.