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

PLS-00400: different number of columns between cursor SELECT statement and return value

1 Answers  


ORA-00028: your session has been killed

1 Answers  


ORA-06135: NETTCP: connection rejected; server is stopping

1 Answers  


ORA-31116: Tablespace not specified correctly

1 Answers  


ORA-13414: invalid pyramid parameter

1 Answers  






ORA-29879: cannot create multiple domain indexes on a column list using same indextype

1 Answers  


ORA-26004: Tables loaded through the direct path may not be clustered

1 Answers  


ORA-39304: during sync/swap, object "string" conflicts: "string"

1 Answers  


DRG-50608: unexpected end of data

1 Answers  


ORA-14165: MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations

1 Answers  


ORA-28302: User does not exist in the LDAP directory service.

1 Answers  


QSM-01049: semi-join check failed for materialized view, string

1 Answers  


Categories