ORA-39727: COMPATIBLE must be set to 10.0.0.0.0 or higher



ORA-39727: COMPATIBLE must be set to 10.0.0.0.0 or higher..

Answer / guest

Cause: An add/drop column operation for compressed table has
been performed on the database. This requires COMPATIBLE to
be set to 10.0.0.0.0 or higher during upgrade from 9.2 to a
10i or higher release.

Action: Set COMPATIBLE to 10.0.0.0.0 and retry the upgrade.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-03099: job cancelled at user request

1 Answers  


ORA-22954: This multiset operation is not supported for this element type.

1 Answers  


PLS-00484: redundant exceptions 'string' and 'string' must appear in same exception handler

1 Answers  


ORA-38502: invalid XML tag: string

1 Answers  


TNS-12557: TNS:protocol adapter not loadable

2 Answers  






SQL-02105: Inconsistent cursor cache. Global cursor not found

1 Answers  


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

1 Answers  


ORA-00826: cannot set sga_target for an ASM instance

1 Answers  


AMD-00137: prefix "string" exceeds maximum permitted length of string characters

1 Answers  


ORA-28113: policy predicate has error

1 Answers  


ORA-38481: ADT "string" is used for a dependent object.

1 Answers  


EXP-00034: error on rowid: file# number block# number slot# number

1 Answers  


Categories