Database Structures in Oracle9i
This course is included in our On-demand training solution.
To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files
Anyone wanting to learn about Oracle9i database administration
An understanding of database concepts and technologies
Database Structures in Oracle9i describe the contents of an Oracle9i database data dictionary and explain how to use it. query an Oracle 9i database data dictionary to access information about an underlying database. describe the purpose and content of an Oracle9i database control file and explain how to manage it. multiplex an Oracle 9i database control file using the SPFILE. describe the structure of the Oracle9i database redo log files and explain how they work and how to archive them. describe how to manage redo log groups and members and how to obtain information about them. add a new multiplexed log file to an Oracle9i database.