ORA-01640: cannot make tablespace read only with active
transactions
- 1 Answers
- 3725 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 |
RMAN-06734: Do you really want to drop all backups and the database (enter YES or NO)?
NNL-00404: TTL: string
ORA-38709: Recovery Area is not enabled.
ORA-13024: polygon has less than three segments
ORA-00266: name of archived log file needed
ORA-01101: database being created currently mounted by some other instance
ORA-33010: (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.
NZE-28885: No certificate with the required key usage found.
DGM-16949: "string" was not found
KUP-02006: script line too long
RMAN-06478: WARNING: datafile copy 'string' cannot be found on disk
ORA-28235: algorithm not available
Oracle Errors 
