The Database Design Resource Center

Users in Oracle | Oracle Backup | Oracle Recovery | Oracle Indexes | Oracle Export
Oracle Import | Oracle Partitions | Oracle Scheduler | Oracle log files | Redefining Oracle Objects

Oracle DBA : Common tasks

Welcome to the Oracle DBA section of this site

In this section, you will find a set of common tasks needed to be mastered and performed by any DBA. The articles are basic level, and some are graphic intensive, so you will need some network speed to read them.

I recommend that you print each article for better reading experience. Use landscape orientation on your printer.

The Oracle Database System from Oracle Corporation is most likely the most widespread and popular Database System in the world. It is increasing with a very high speed in Linux environments, but is also gaining market shares in virtually all environments.
I have wanted to present to you a set of articles for Oracle DBA's, which include:

  • Adding users in Oracle
  • Backup and restore
  • Import and export data
  • Job scheduling

and much more. So, here it is:

DISCLAIMER: All programming examples within the articles are meant for illustration purposes only, and The Database Design Resource Center holds no warrant for correctness if used.

  • A very basic task is to add users in Oracle.
  • One of the most important tasks is to establish and perform an Oracle Backup. Without it, you are leading a dangerous life...
  • As a professional Oracle DBA, after having established sound backup procedures, let us hope you never will need to perform an Oracle Recovery. Chances are, however, that you may have to some day...
  • Indexes are an important performance enhancement facility. In this article, we look at some options and tools for creating Oracle Indexes.
  • If you need to, you can export parts of, or the complete database, to a flat file using Oracle Export. Nice feature, but very old-fashioned...
  • After you have performed an Oracle Export, you can use the Oracle Import function to load data into another database. Very useful feature, but as with Oracle Export: A bit old-fashioned. However, it does the job.
  • Some database tables may contain millions of rows, and performance may slow down. A good solution for the Oracle DBA may be to split such tables into Oracle Partitions.
  • Instead of manually starting different database tasks, the Oracle DBA can automate the whole process by using the Oracle Scheduler.
  • In order to perform Oracle backup and recovery, you need to have a redo log up and running. This article looks at aspects when dealing with Oracle log files.
  • The last article in the Oracle DBA section is about performing real-time changes to tables and other database objects: Redefining Oracle Objects.

Return to Database Design home

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:

What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Database Normalization eBook:

Database Normalization eBook

Copyright © /
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.