《{管理信息化ORACLE}oracleocpLess03DBDBCAMB3》由会员分享,可在线阅读,更多相关《{管理信息化ORACLE}oracleocpLess03DBDBCAMB3(18页珍藏版)》请在金锄头文库上搜索。
1、Creating an Oracle Database,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,Planning the Database,As a
2、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 stora
3、ge requirementsdue to type or size? The overall database design A backup strategy for the database,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
4、Automatic teller machine (ATM) transactions General Purpose: Retail billing system, for example, of a software house or a nursery,Database Configuration Assistant (DBCA),Using the DBCA to Create a Database,Using the DBCA to Create a Database,3,4,Using the DBCA to Create a Database,5,6,7,Using the DB
5、CA to Create a Database,8,9,Using the DBCA to Create a Database,A,B,10,Using the DBCA to Create a Database,11,12,Password Management,A,B,C,Creating a Database Design Template,Using the DBCA to Delete a Database,3,1,2,Removing an Oracle Database Full Notes Page,Summary,In this lesson, you should have
6、 learned how to use the DBCA to: Create a database Create a database design template Generate database creation scripts,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,