ORA-01239: database must be in ARCHIVELOG mode to use
external cache



ORA-01239: database must be in ARCHIVELOG mode to use external cache..

Answer / guest

Cause: An online file uses an external cache, but the
database is in NOARCHIVELOG mode. Since an external cache
may require media recovery this can not be allowed.

Action: Change database to be in ARCHIVELOG mode or do not
use an external cache.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-01001: query rewrite not enabled

1 Answers  


ORA-25330: PL/SQL associative arrays may not be used with AQ array operations

1 Answers  


ORA-30188: reserved for future use

1 Answers  


ORA-07253: spdes: semctl error, unable to destroy semaphore set.

1 Answers  


DRG-12606: error encountered while parsing COLUMNS list

1 Answers  






ORA-38957: Target database not 10.0.0.0 compatible

1 Answers  


ORA-28000: the account is locked

1 Answers  


ORA-00125: connection refused; invalid presentation

1 Answers  


ORA-00021: session attached to some other process; cannot switch session

1 Answers  


ORA-25144: invalid option for CREATE TABLESPACE with TEMPORARY contents

1 Answers  


ORA-39060: table(s) dropped because of conflict with master table

1 Answers  


NZE-28751: memory allocation failure

1 Answers  


Categories