Backup and restore for views
I make extensive use of views in my database, more views than tables.
No idea how the backup is handling views, but restore restores the views as tables, with data!
This is not how it should work.
A view is basically just a stored query, certainly not a table.
Since it’s screwed up, how can I backup everything except views? Then I could restore just that.
Easy enough to save just the view definitions separately, and then to restore, execute the view definitions after everything else.
Please help. I have 267 tables and 467 views.
Subject
Views
Written By
Posted
Backup and restore for views
1444
March 15, 2022 08:02AM
608
March 15, 2022 11:23AM
499
June 16, 2022 05:48PM
520
June 16, 2022 08:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.