TAILIEUCHUNG - 3 Creating an Oracle Database

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 | Creating an Oracle Database Oracle Database 10g: Administration Workshop I 3- 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 Oracle Database 10g: Administration Workshop I 3- 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? The overall database design A backup strategy for the database Planning the Database It is important to plan how the logical storage structure of the database will affect system performance and various database management operations. For example, before

• Cơ sở dữ liệu
• workshopI
• oca 10g
• oracle
• database
• dba
• database
• cơ sở dữ liệu
• công nghệ thông tin