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-27025: skgfqsbi: invalid media manager context area size

1 Answers  


ORA-25443: duplicate column value for table alias: string, column number: string

1 Answers  


ORA-12597: TNS:connect descriptor already in use

1 Answers  


DRG-12302: invalid column list

1 Answers  


NPL-00418: received malformed ASN.1 object identifier

1 Answers  






TNS-00006: INTCTL: HOST variable is not defined

1 Answers  


ORA-16092: dependent archive log destination is not active

1 Answers  


ORA-23475: key column string must be sent and compared

1 Answers  


NNL-01010: Forwarding contexts allocated: number

1 Answers  


NZE-29095: Index is not correct.

1 Answers  


TNS-12650: No common encryption or data integrity algorithm

1 Answers  


ORA-24281: invalid access past the maximum size of LOB parameter string

1 Answers  


Categories