ORA-01640: cannot make tablespace read only with active
transactions
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-25300: Cannot drop buffer for queue with buffered subscribers
ORA-32631: illegal use of objects in MODEL
ORA-12685: Native service required remotely but disabled locally
ORA-30102: 'string' is not in the legal range for 'string'
LSX-00009: data missing for type "~S"
ORA-31498: description and remove_description cannot both be specified
LFI-00120: Unable to parse root filename string.
PLS-00719: only widening of attribute 'string' constraints is allowed
ORA-38737: Expected sequence number string doesn't match string
NNO-00113: line string: alias data already exists, all other data ignored
ORA-10922: Temporary tablespace group is empty
ORA-24853: failed to connect thread to shared subsystem