Oracle DB Error ORA-01640 cannot make tablespace read only with active transactions

Oracle DB Error ORA-01640 cannot make tablespace read only with active transactions

The following is the cause of this error:

An attempt was made 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 you can take to resolve this issue: 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.


Tags: Database, Education, Software




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution