Kaplan - Earn Your IT Degree Online
If you are interested in advancing your IT career in programming, web development, database management, or networking, Kaplan University will give you the knowledge and skills you need.

Oracle Magazine - Free Subscription
Oracle Magazine contains technology-strategy articles, sample code, tips, Oracle and partner news, an all-new Oracle Developer section for Java developers, and more. No hidden or trial offers. Publication is absolutely free to those who qualify.

Attribute Naming - What standard do you use?

This purpose of this article is to assist the DBA to identify inconsistencies in column naming and / or data types within a target application.

What Happens when You Start a Database
When you start a database, basically three operations are performed :

Removing Duplicate Records.

Identify if the entire record is duplicated or if the table has duplicate Primary Keys.

Oracle's Optimal Flexible Architecture .

All too often I have come across databases that do not conform to the OFA guidelines. This page is an attempt to highlight that there is an Oracle guideline for setting up Oracle databases and to outline how I have interpreted and implemented OFA mostly within Oracle Finacials environments, together with some of the more practical benefits of using the guidelines.

Copying and / or Renaming a Database .

In this example we will rename the CANDB database to DEV and move it to the appropriate OFA structure.

Moving data out of Oracle and back in

exp and imp are probably the most important utilities for Oracle DBAs but, unfortunately, they are far from being the last word in efficiency.

General Oracle Database Administration

One can create and modify Oracle databases using the Oracle "dbca" (Database Configuration Assistant) utility. The dbca utility is located in the $ORACLE_HOME/bin directory. The Oracle Universal Installer (oui) normally starts it after installing the database server software.

Oracle Database Internals

Answers Questions about Oracle Database Internals

Move a datafile to a different disk location

Procedure to copy or clone a database from one machibe to another

Oracle, JD Edwards, PeopleSoft, and Retek are registered trademarks of Oracle Corporation and/or its affiliates.

Site Map  •  FAQs  •  Link to Us  •  Educational Gift Ideas  •  Add a Course  •  Contact Us

© 2008 Learning Link Finders, Inc. - All Rights Reserved - Modified on 01/01/08

All trademarks and registered trademarks appearing on the Docnmail.com website are the property of their respective owners.
By providing links to other sites, Learning Link Finders, Inc. does not guarantee, approve or endorse the information or products available
at these sites, nor does a link indicate any association with or endorsement by the linked site to Docnmail.com.