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

KUP-04076: file name cannot contain a path specification: string

1 Answers  


ORA-24392: no connection pool to associate server handle

1 Answers  


ORA-14294: Number of partitions does not match number of subpartitions

1 Answers  


DRG-51025: an invalid character was passed to the stemmer

1 Answers  


TNS-01110: Mismatch - password unchanged

1 Answers  






ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

0 Answers  


EXP-00027: failed to calculate ORACLE block size

1 Answers  


LSX-00264: attribute "~S" is prohibited (may not occur)

1 Answers  


ORA-19002: Missing XMLSchema URL

1 Answers  


PLS-00560: character set mismatch

1 Answers  


ORA-14262: new subpartition name must differ from the old subpartition name

1 Answers  


ORA-16211: unsupported record found in the archived redo log

1 Answers  


Categories