i would like to know.
1. if a table is dropped can this statement be rolled back?
2. If in sql plus ROLLBACK is written does it mean that whatever was the previous statement that will be rolled back? (no savepoitn defined)
3. Supposing a ROLLBACK is done on sql plus prompt. and on the side line lot of other applications are using the database...does this rollback on this sql plus impact there also?
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…