I have corrupted index in system tablespace:
Index Name: I_OBJ1
Table Name: OBJ$
How do I rebuild this index and waht are the potensial problems?
The corruption was found through trace file.
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
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…