Tag: Oracle

Community

Developing a Database Security Plan

Oracle Security: Chapter 7, By Marlene Theriault & William Heney – There are many steps to securing your system and its data. But one of the first–and one that too few organizations take–is the development of a security policy that outlines and maps out the enforcement of a security plan. We’ve in

Community

Rock-Solid Replication

By Cameron O’Rourke – Replication involves synchronizing some or all of your application data across multiple databases in a distributed system. In this column, I explain why you might use replication and describe some Oracle technologies you can use to implement it.

Community

Flashback Query in Oracle9i

by Jayeshkumar Patel – What do you do when an application causes sensitive data to be deleted, and you need to get that data back? Prior to Oracle9i, you had to recover the database and roll forward to the point you were interested in. With Oracle9i Flashback Query, you can achieve get the da

Community

Learning Oracle PL/SQL

Sample Chapter – Designed for both new programmers and those experienced in other languages, this book presents the core features of Oracle’s PL/SQL language in an easy-to-read format. Learning Oracle PL/SQL will bring programmers up to speed on the most important aspects of PL/SQL, including web an

Community

Certifying: DBA Fundamentals II

By Jim DiIanni – The Oracle9i Performance Tuning exam is the second exam you must take to achieve the Oracle Certified Professional (OCP) level of certification. This is the first of two columns regarding the topics you will likely encounter on the Oracle9i Performance Tuning exam, and it includes a