Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01145: offline immediate disallowed unless media
recovery enabled
- 1 Answers
- 9733 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-02899: smscre: Cannot create SGA with Extended Shared Memory feature
ORA-08195: Flashback Table operation is not supported on partitions
PLS-00567: cannot pass NULL to a NOT NULL constrained formal parameter
ORA-24054: cannot propagate to an Oracle 8.0.3 release or lower release
ORA-02821: Unable to read the requested number of blocks.
ORA-22904: invalid reference to a nested table column
TNS-00073: * stop/abort - stop the process_name
IMP-00007: must be a DBA to import objects to another user's account
TNS-12222: TNS:no support is available for the protocol indicated
DRG-11004: duplicate or conflicting value for string
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-06029: NETASY: port assignment failure
Oracle Errors 
