I receive the following error on opening(alter database open;) my recovered database
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error 
I realised that I can't even create a user/tablespace/datafile in this recovered database. The same error appears.
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …