Email Alerts
-
SearchOracle.com Lessons Learned Library
SearchOracle.com has identified your FAQs and compiled applicable expert answers in an easy-to-follow format. Tip
-
Database down! Bring it back alive!
This excerpt from "Everyday Oracle DBA" explains what to do in the event that your database goes down and you're under pressure from your managers to get it back up as soon as possible. Tip
-
Recovering from user errors
This book excerpt explains how to recover a dropped table using Flashback technology, manage the recycle bin, perform a Flashback Table operation, recover from user errors using Flashback Versions Query and perform transaction-level recovery using Fl... Tip
-
Recover Oracle databases
This book excerpt explains how to recover from the loss of a controlfile, redo log file or system-critical or nonsystem-critical datafile. Tip
-
A bit wiser with Oracle technology
Learn how to use a metadata repository to identify a "source of truth" for each customer attribute in a data warehouse. This tip explains how to use the base-two numbering values of the primary key in the data source reference table and bitwise logic... Tip
-
The relational database dictionary
This tip highlights three definitions from C.J. Date's new book, "The Relational Database Dictionary": 'primary key,' 'relational model' and 'table.' Tip
-
Developer and DBA: Working together for greater efficiency
There is often a disconnect between developers and DBAs. Bridging the gap between database design/development and operations management can make the difference between an efficient, well-managed business application and one that fails to meet service... Tip
-
Regulatory compliance and the DBA: What you need to know
At the top of business executives' minds today is how to meet regulatory compliance and corporate governance rules. New laws are changing the way companies collect, retain and manage information. DBAs need to understand what is happening in the corpo... Tip
-
Building an Oracle team
In today's e-business environment, maintaining high availability, optimizing performance and delivering consistent service are essential. Building and maintaining an effective Oracle team is now more important than ever. This tip explains how to achi... Tip
-
See who is logged into the database
This script is used to see who is logged into the database. Tip