Oracle Solution for Error ora-01784

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

What triggered the 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.

What should we do to fix it:

Do not specify RECOVERABLE, or restart the database with media recovery enabled.