ORA-01784: RECOVERABLE cannot be specified with database
media recovery disabled
- 1 Answers
- 2705 Views
- I also Faced
- E-Mail Answers
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-29370: pending area is already active
PCC-02013: unknown escape sequence
PLS-00643: booleans, index tables, records and cursors not allowed in SQL statements
ORA-24379: invalid user callback type
ORA-38490: invalid name: quotes do not match
TNS-12570: TNS:packet reader failure
ORA-39092: unable to set SCN metadata for object "string.string" of type string
ORA-24503: codepoint length overflows for piecewise operation
ORA-24000: invalid value string, string should be of the form [SCHEMA.]NAME
ORA-06313: IPA: Shared memory failed to initialise
QSM-00789: the string string is invalid for directive string
NNF-02005: NIS key string does not exist in map string
Oracle Errors 
