Naming your database correctly is important. While names like Enterprise, Picard or B5 might sound cool they are not very practical. We recommend that you use a four to six character naming standard using the following format:

AAATT

Where: AAA = Application Identifier

             TTT = Database Type

The Application identifier defines the principal use of the database. If it was an accounting application you might use ACT for the Application Identifier.

The database type implies that there are different kinds of databases associated with a given application identifier. The most common database types are:

   - Production – PRD

   - Test – TST

   - QA – QA

   - Development – DEV

Given our example then, your production accounting database would be called ACTPRD, and your test accounting database would be called ACTTST.

This is an excerpt from the bestselling "Easy Oracle Jumpstart" by Robert Freeman and Steve Karam (Oracle ACE and Oracle Certified Master).  It’s only $19.95 when you buy it directly from the publisher here.

If you like Oracle tuning, you may enjoy the new book "Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.