ORA-04940: unsupported optimization of Oracle binary, check
alert log for more info



ORA-04940: unsupported optimization of Oracle binary, check alert log for more info..

Answer / guest

Cause: ORACLE binary has been optimized with unsupported
options or a required option has not been used.

Action: Check the documentation for a list of supported and
required flags for the optimizing utility that you used to
optimize ORACLE. Shutdown the instance, optimize ORACLE
again with supported combination of options and restart the
instance.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LSX-00102: duplicate element "~S"

1 Answers  


ORA-22924: snapshot too old

1 Answers  


EXP-00079: Data in table "string" is protected. Conventional path may only be exporting partial table.

1 Answers  


ORA-39045: invalid metadata remap name string

1 Answers  


ORA-14124: duplicate REVERSE clause

1 Answers  


NCR-01019: NCRS: Checksumming failure.

1 Answers  


ORA-12465: Not authorized for read or write on specified groups or compartments

1 Answers  


PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list

1 Answers  


ORA-02187: invalid quota specification

1 Answers  


RMAN-08157: script string written to file string

1 Answers  


ORA-19512: file search failed

1 Answers  


ORA-01236: Error string occurred during initialization of file header access

1 Answers  


Categories