Public Synonym

If you are the owner of a table or view and you create a public synonym for the table or view, when you grant select on the synonym mane you are in effect granting select on the table or view. The synonym eliminates the need to clarify the table or view with the schema.table name.And...

Read More

Oracle 11g Data Compression Tips for the DBA

One of the exciting new features of Oracle 11g is their inline data compression utility. While it is true that data storage prices have fallen dramatically over the last decade, and continue to fall rapidly, Oracle data compression has far more appealing benefits than simply saving...

Read More

Oracle Critical Patch Update January 2009

The Critical Patch Update for January 2009 was released on January 13, 2009. Oracle strongly recommends applying the patches as soon as possible.The Critical Patch Update Advisory is the starting point for relevant information. It includes the list of products affected, pointers...

Read More