Prerequisites for Database Creation


To create a new database, you must have the following:

  • A privileged account authenticated either by the operating system or by use of a password file.

  • Sufficient memory on the computer to allow the instance to start. This needs to be large enough for the entire SGA, the Oracle executables, and the processes supporting the instance.

  • Sufficient disk space for the planned database. Included in your calculations needs to be the disk space that is necessary for the database, its data files, the online redo log files (including the multiplexed files), and the control files (including any multiplexed versions).

  • Sufficient disk space for archive logs for the planned database. Include in your calculations sufficient disk space to store archived redo log files. Although a data warehouse may not need to have archive logs for normal operations, it is important to have them for a period of time to facilitate recovery of the database.

Chapter 2, "Getting Started with the Oracle Server," covers authentication further.




    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