Call: +44 (0)1904 557620 Call
Blog

Pete Finnigan's Oracle Security Weblog

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

[Previous entry: "Buffer overflows and hacking book list"] [Next entry: "Application Security Inc has made a search page available for the ploicy check list"]

Edward Stanglers next post in the not running catpatch.sql series



I have just seen Ed's next post in this series of issues / problems encountered if you do not run the full upgrade scripts and catpatch.sql. This time he talks about missing a COMPRESSION column in DBA_TABLES.

This was as Ed points out an exciting feature that allows faster full table scans by eliminating redundant column data. This feature was missing from 9.2.0.1 dictionary views but fixed in 9.2.0.3 only if catpatch.sql is run. Read Edwards comments on the dangers of not running catpatch.sql.