ORA-00409: COMPATIBLE needs to be string or higher to use
AUTO SEGMENT SPACE MANAGEMENT



ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT..

Answer / guest

Cause: This is due to migrating from an older release of
Oracle with tablespaces created using AUTO SEGMENT SPACE
MANAGEMENT. To open the database, the COMPATIBLE parameter
needs to be set to the specified value.

Action: Shutdown and startup with the specified
compatibility setting.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

1 Answers  


UDE-00015: invalid context or job state for parameter, 'string'.

1 Answers  


SQL-02139: Unable to get the OCI handles

1 Answers  


ORA-25101: duplicate REBUILD option specification

1 Answers  


ORA-40202: column string does not exist in the input table string

1 Answers  






ORA-27066: number of buffers in vector I/O exceeds maximum

1 Answers  


ORA-09792: sllfop: cannot allocate read buffer.

1 Answers  


ORA-12921: database is not in force logging mode

1 Answers  


O2I-00133: An error occurred for which no message is available

1 Answers  


ORA-06908: CMX: error during transfer of ORACLE_SID

1 Answers  


TNS-12681: Login failed: the SecurID card does not have a pincode yet

1 Answers  


ORA-12650: No common encryption or data integrity algorithm

1 Answers  


Categories