Oracle database error code ORA-00409 – COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT

Oracle Database Error Code ORA-409 Description :
COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
Error 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.

How to Solve :
Shutdown and startup with the specified compatibility setting.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»