Chapter 3. Creating a Database


Terms you'll need to understand:

  • CREATE DATABASE

  • Oracle Database Configuration Assistant

  • ODCA

  • Control files

  • Oracle Base

  • Oracle Home

  • Oracle SID

  • Templates

  • SID

  • Online Transaction Processing

  • MAXLOGFILES

  • MAXLOGMEMBERS

  • MAXLOGHISTORY

  • MAXDATAFILES

Concepts you'll need to master:

  • Understand the prerequisites necessary for database creation.

  • Create a database using the Oracle Database Configuration Assistant.

  • Create a database manually.

Creating a database, although not a task that you will undertake every day, is certainly a task that will be very important in your career as a DBA. It is something that will take thought and planning and something that you should understand early, both in your career and in your exam preparations. This chapter shows you how to create a database manually and use the GUI interface.

Creating a database is, naturally, the first step in managing a database. The database may be one created automatically as a part of the initial Oracle 9i Server installation, or it can be created later, either using the Database Configuration Assistant or manually with database creation scripts. If you are migrating a database from an earlier version (8i, for example), you can accomplish this either through the use of the database migration assistant or the use of migration scripts.

Database creation is the task of preparing several operating system files. It is a task needed only once for a database, regardless of how many data files that database ultimately has. Because of the importance of this task, careful decisions must be made on many of the database settings.



    Oracle 9i Fundamentals I Exam Cram 2
    Oracle 9i Fundamentals I Exam Cram 2
    ISBN: 0789732653
    EAN: 2147483647
    Year: 2004
    Pages: 244
    Authors: April Wells

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net