Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01145: offline immediate disallowed unless media
recovery enabled
- 1 Answers
- 9631 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: ALTER TABLESPACE ... OFFLINE IMMEDIATE or ALTER
DATABASE DATAFILE ... OFFLINE is only allowed if database is
in ARCHIVELOG mode.
Action: Take tablespace offline normally or shutdown abort.
Reconsider your backup strategy. You could do this if you
were archiving your logs.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 2 No |
ORA-24028: cannot create a reciever non-repudiable single consumer queue
ORA-12686: Invalid command specified for a service
ORA-09368: Windows 3.1 Two-Task driver unable to spawn ORACLE
ORA-16600: Failover operation can only be submitted at target database.
ORA-12477: greatest lower bound resulted in an invalid OS label
ORA-25240: message ID and dequeue condition/correlation ID specified in dequeue options
PCC-02424: The number of values and host variables does not match
ORA-01310: requested return type not supported by the lcr_mine function
DRG-10000: failed to read column string.string
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
ORA-16608: one or more sites have warnings
SQL*Loader-00640: Variable length field was truncated.
Oracle Errors 
