![]() |
Profile |
Contact |
Search |
Cart |
| Oracle8 Administration: Exploring the Database Structure |
| Course Status: | Released | Course Features |
| Course Language: | English | |
| Course Duration: | 4 Hours | |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Database administrators |
| Prerequisites |
| Completion of the Oracle Introduction curriculum |
| Course Aim |
| To introduce the data dictionary and to discuss the maintenance issues associated with redo log files and control files |
| Learning Objectives |
| Describe the structure and purpose of the data dictionary. Identify standard administrative scripts. Distinguish between procedures and packages. Explain the use of the control file. Discuss the purpose of online redo log files. Maintain control files and redo log files. |
| Topics Covered |
| The data dictionary - Structure of the data dictionary - Administrative scripts - Stored procedures and packages - Hands-on: Creating data dictionary views The control file - Introducing the control file - Managing the control file - Hands-on: Multiplexing the control file Using the redo log files - Obtaining information - Multiplexing and maintenance - Hands-on: Maintaining redo log files - Hands-on: Maintaining redo log files in OEM |