|
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 datafiles, redo log files and control files. Oracle9i 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 Answers: 1: This command will not fix the problem. 2: There is no EXTENT MANAGEMENT ORACLE option in the CREATE TABLESPACE command. 4: An OMF tablespace is allowed; datafiles, control files and redo log files can be created by OMF. Reference: OCP Oracle9i 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: Oracle9i Database Administration and Management Features
|