Search results

Thank you for the responses. I was in the middle of testing all available avenues. The last time this index was added, the databases fell out of sync (as they would do) but the solution was to backup and restore the database and re-apply ai and roll forward recovery. The database in question...

Mainly due to the size of the index that could be applied and the associated delays in processing this would cause. Is there no way to re-align the production and dr databases?

Hello, I was wondering whether someone could possibly help. We are wanting to add an index to our database so it would be nice to have after-imaging switched off whilst this goes ahead. When we use aioff then probkup enableai, the AI sequence starts again at 1. Is there a way to stop AI...

Hi Tom, Many thanks for the advise and the code - is shall try to get this implemented. The code will help with moving the tables in the schema area out to a "unused" area but is there a VST that will highlight whether the tables have data in as these will need to be moved to a more appropriate...

Hi, I am currently in the process of creating reports to determine tables that are (wrongly) stored in the schema area of a database. The data i want is available from the tabanalys command but its difficult to interpret into reports and takes forever. I have managed to go through the VST's to...