First I got the ORA-01578 data block corrupted on file #3, block #4159 error message. Then, I found out that corruption is on the rollback segment RB3. I took the RB3 offline. I tried to remove it and recreate it again. But, I got another ORA-01545 rollback segment 'RB3' specified not available. Yes, it was pending offline not offline. Please advice!
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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