|
Explanation: You can set the DB_CREATE_FILE_DEST parameter using the ALTER SESSION command and re-issue the statement. You should define directories for OMF data files, redo log files and control files. Oracle 9i gives you two new initialization parameters, DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n, to specify the location where Oracle will create and manage OMFs; n can take a value from 1 to 5. Incorrect Answer: 1: This command will not fix the problem. 2: There is no EXTENT MANAGEMENT ORACLE option in the CREATE TABLE SPACE Command. 4: An OMF table space is allowed; data files, control files and redo log files can be created by OMF. Reference: OCP Oracle 9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 2-12 Chapter 1: Oracle 9i Database Administration and Management Features
|