3 Creating an Oracle Database Copyright 2005 Oracle

Objectives After completing this lesson, you should be able to do the following: • Create a database with the Database Configuration Assistant (DBCA) • Create a database design template with the DBCA • Generate database creation scripts with the DBCA 3 -2 Copyright © 2005, Oracle. All rights reserved.

Planning the Database As a DBA, you must plan: • The logical storage structure of the database and its physical implementation: – How many disk drives do you have for this? – How many data files will you need? (Plan for growth. ) – How many tablespaces will you use? – Which type of information will be stored? – Are there any special storage requirements due to type or size? • • 3 -3 The overall database design A backup strategy for the database Copyright © 2005, Oracle. All rights reserved.

Databases: Examples • Data Warehouse: – Research and marketing data – State or federal tax payments – Professional licensing (doctors, nurses, and so on) • Transaction Processing: – Store checkout register system – Automatic teller machine (ATM) transactions • General Purpose: – Retail billing system, for example, of a software house or a nursery 3 -4 Copyright © 2005, Oracle. All rights reserved.

Database Configuration Assistant (DBCA) 3 -5 Copyright © 2005, Oracle. All rights reserved.

Using the DBCA to Create a Database 3 -6 Copyright © 2005, Oracle. All

Using the DBCA to Create a Database 3 4 3 -7 Copyright © 2005,

Using the DBCA to Create a Database 5 6 7 3 -8 Copyright ©

Using the DBCA to Create a Database 8 9 3 -9 Copyright © 2005,

Using the DBCA to Create a Database A 10 B 3 -10 Copyright ©

Using the DBCA to Create a Database 11 12 3 -11 Copyright © 2005,

Password Management A B C 3 -12 Copyright © 2005, Oracle. All rights reserved.

Creating a Database Design Template 3 -13 Copyright © 2005, Oracle. All rights reserved.

Using the DBCA to Delete a Database 1 2 3 3 -14 Copyright ©

Summary In this lesson, you should have learned how to use the DBCA to:

Practice Overview: Using the DBCA This practice covers the following topics: • Creating the ORCL database by using the DBCA • Unlocking the HR schema Note: Completing the database creation and unlocking the HR schema is critical for all following practice sessions. Optionally: • Creating the ORCL database design template by using the DBCA • Creating database creation scripts with the DBCA 3 -17 Copyright © 2005, Oracle. All rights reserved.