ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled

Cause: 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: Do not specify RECOVERABLE, or restart the database with media recovery enabled.

Error Type: ORA

• Additional information for ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled01784
Discussions and solutions for Oracle Database Error ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled Developer anwers for Oracle Database Error ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled FAQs for ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled search others tips for ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled