Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-01640: cannot make tablespace read only with active
transactions



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

Post New Answer

More Oracle Errors Interview Questions

ORA-01036: illegal variable name/number

1 Answers  


ORA-26699: STREAMS message consumer string already exists

1 Answers  


LPX-00218: invalid character ~1u ('~2c')

1 Answers  


ORA-37127: (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.

1 Answers  


ORA-19001: Invalid storage option specified

1 Answers  






DRG-50939: parser not set

1 Answers  


ORA-10652: Object has on-commit materialized views

1 Answers  


ORA-00364: cannot write header to new log member

1 Answers  


ORA-39308: application/database upgrade internal error: "string"

1 Answers  


ORA-16542: unrecognized operation

1 Answers  


LSX-00134: attribute "~1S" has invalid qualification "~2S"

1 Answers  


QSM-01526: query rewrite is disabled for equivalence, string

1 Answers  






Categories