oracle ocp Less03_DB_DBCA_MB3

1、3Copyright 2005, Oracle. All rights reserved.Creating an Oracle Database3-2Copyright 2005, Oracle. All rights reserved.ObjectivesAfter 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 wi

2、th the DBCAGenerate database creation scripts with the DBCA3-3Copyright 2005, Oracle. All rights reserved.Planning the DatabaseAs 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 yo

3、u need? (Plan for growth.) How many tablespaces will you use? Which type of information will be stored? Are there any special storage requirementsdue to type or size?The overall database designA backup strategy for the database3-4Copyright 2005, Oracle. All rights reserved.Databases: ExamplesData Wa

4、rehouse: 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) transactionsGeneral Purpose: Retail billing system, for example, of a software house or a nurser

5、y3-5Copyright 2005, Oracle. All rights reserved.Database Configuration Assistant (DBCA)3-6Copyright 2005, Oracle. All rights reserved.Using the DBCA to Create a Database3-7Copyright 2005, Oracle. All rights reserved.Using the DBCA to Create a Database343-8Copyright 2005, Oracle. All rights reserved.

6、Using the DBCA to Create a Database5673-9Copyright 2005, Oracle. All rights reserved.Using the DBCA to Create a Database893-10Copyright 2005, Oracle. All rights reserved.Using the DBCA to Create a DatabaseAB103-11Copyright 2005, Oracle. All rights reserved.Using the DBCA to Create a Database11123-12

7、Copyright 2005, Oracle. All rights reserved.Password ManagementABC3-13Copyright 2005, Oracle. All rights reserved.Creating a Database Design Template3-14Copyright 2005, Oracle. All rights reserved.Using the DBCA to Delete a Database3123-15Copyright 2005, Oracle. All rights reserved.Removing an Oracl

8、e Database Full Notes Page3-16Copyright 2005, Oracle. All rights reserved.SummaryIn this lesson, you should have learned how to use the DBCA to:Create a databaseCreate a database design template Generate database creation scripts3-17Copyright 2005, Oracle. All rights reserved.Practice Overview: Using the DBCAThis practice covers the following topics:Creating the ORCL database by using the DBCAUnlocking the HR schemaNote: Completing the database creation and unlocking the HR schema is critical for all following practice sessions.Optionally:Creating the ORC