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-29707: inconsistent value string for initialization parameter string with other instances

1 Answers  


ORA-23403: refresh group "string"."string" already exists

1 Answers  


ORA-07224: sfnfy: failed to obtain file size limit; errno = string.

1 Answers  


ORA-25294: Queue string has a buffer

1 Answers  


ORA-38726: Flashback database logging is not on.

1 Answers  


ORA-06593: %s is not supported with natively compiled PL/SQL modules

1 Answers  


ORA-13283: failure to get new geometry object for conversion in place

1 Answers  


QSM-01100: containment check failed for mv, string

1 Answers  


ORA-09353: Windows 32-bit Two-Task driver unable to open event semaphore

1 Answers  


ORA-32010: cannot find entry to delete in SPFILE

1 Answers  


PCC-00036: No input file name specified

1 Answers  


PLS-00620: type mismatch found at 'string' among operands in a COALESCE expression

1 Answers  


Categories