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

PCC-01301: Your Pro*PL/I authorization is about to expire

1 Answers  


KUP-04074: no write access to directory object string

2 Answers  


ORA-31648: Timeout before master process string finished initialization.

1 Answers  


UDE-00050: Unable to setup parameter processing.

1 Answers  


ORA-33215: (CINSERT07) You cannot add session-only values to the workspace object dimension.

1 Answers  


ORA-15103: conflicting or duplicate REPAIR options

1 Answers  


ORA-00299: must use file-level media recovery on data file string

1 Answers  


RMAN-20222: datafilename not found in recovery catalog or is ambiguous

1 Answers  


ORA-02838: Unable to arm signal handler for the alarm signal

1 Answers  


RMAN-06735: Do you really want to drop the database (enter YES or NO)?

1 Answers  


ORA-19025: EXTRACTVALUE returns value of only one node

1 Answers  


ORA-29817: non-supported option with disassociate statement

1 Answers  


Categories