ORA-01640: cannot make tablespace read only with active
transactions
- 1 Answers
- 3421 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: Attempting to make a tablespace read only while there
are active transactions in the database. All transactions
must commit or rollback to insure that there is no undo for
a tablespace before it can be made read only. This includes
in doubt distributed transactions.
Action: Prevent any more transactions from being started.
Putting the database in restricted mode usually helps. If
there are any in doubt transactions they must also be resolved.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-00277: illegal option to the UNTIL recovery flag string
ORA-38465: failed to create the privilege checking trigger due to: string
ORA-31446: this session does not own the lock handle for string
EXP-00070: attempt to free unallocated memory
QSM-02102: mv FROM list references an object in the SYS schema
ORA-06747: TLI Driver: error in listen
ORA-15130: diskgroup "string" is being dismounted
ORA-39315: illegal swap() call: only applys after clone/sync_code
NID-00334: The following datafiles are not checkpointed to string:
NNL-01043: Data stream answer failures: number
QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function
ORA-22977: missing or invalid attribute
Oracle Errors 
