标题: ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled [打印本页] 作者: admin 时间: 2016-7-18 15:20 标题: ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled 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.