Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01640: cannot make tablespace read only with active
transactions
- 1 Answers
- 4184 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-30013: undo tablespace 'string' is currently in use
ORA-09759: osnsbt: bad message received.
ORA-12828: Can't start parallel transaction at a remote site
ORA-38723: Invalid SCN expression.
ORA-08459: invalid format parameter length
PLS-00970: The class name of a method must match that of EXTERNAL NAME clause in the type header
ORA-02739: osncon: host alias is too long
TNS-12601: TNS:information flags check failed
ORA-38454: attribute set not defined for the column being indexed
ORA-22920: row containing the LOB value is not locked
ORA-23312: not the masterdef according to string
ORA-12600: TNS: string open failed
Oracle Errors 
