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-26678: Streams capture process must be created first

1 Answers   Yahoo,


ORA-01491: CASCADE option not valid

1 Answers  


ORA-01537: cannot add data file 'string' - file already part of database

2 Answers  


ORA-16720: no available LOG_ARCHIVE_DEST_n parameters to use

1 Answers  


ORA-19722: datafile string is an incorrect version

1 Answers  


ORA-13601 encountered when generating server alert SMG-3503

0 Answers   DB Experts,


IMG-00512: multiple incompatible scaling parameters found

1 Answers  


ORA-26693: STREAMS string process dropped successfully, but error occurred while dropping rule set string

1 Answers  


ORA-39751: partitioned table on both sides of PARTITIONED OUTER JOIN is not supported

1 Answers  


ORA-36378: (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.

1 Answers  


RMAN-06509: only SPFILE or controlfile can be restored from autobackup

1 Answers  


SQL*Loader-00104: Invalid bad file name on command line

1 Answers  


Categories