Oracle DB Error ORA-01784 RECOVERABLE cannot be specified with database media recovery disabled

Oracle DB Error ORA-01784 RECOVERABLE cannot be specified with database media recovery disabled

The following is the cause of this error:

A CREATE TABLE or CREATE INDEX statement specified RECOVERABLE when the database was running in NOARCHIVELOG mode. Since logs are not being archived, they will be overwritten and the object being created cannot be recovered from a backup taken before the object was created.

Action you can take to resolve this issue: Do not specify RECOVERABLE, or restart the database with media recovery enabled.


Tags: Database, Microsoft, SQL, Oracle, Software, DBMS




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution