I have a server database that has been in uses for a while. I would like to ‘eliminate’ the view indexes from the server DB. This means that I want the server to ‘clean up’ and not even think that a particular view was ever opened. This way the DB will primarily be restored to a fresh state of DATA and very little (if not no) view indexes existing on the server.
What steps would I need to accomplish this? Remember, the server needs to think that the view was NEVER opened on the server…
Subject: Discards built view indexes
I think the only way to delete (not purge) view indexes in r8 is to use compact -D and you may need the -i option also.
From Admin help for -D:
Discards built view indexes. Use this option to compact databases that are not in active use, for example, just before you store databases on tape. Additional system time and resources should be planned to rebuild indexes after restore of the databases. Does copy-style compacting.
Subject: -D option
Will -D not only remove the indexes but removes from the database the indication that an index is ‘dirty’ and should be rebuilt?
Subject: Try a test
Can you create a “copy” of the database for test purposes?
Pat