Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01640: cannot make tablespace read only with active
transactions
- 1 Answers
- 4069 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 |
TNS-00238: Pump number @: string:
what is error treshold?
PCC-00117: Invalid ARRAYLEN length variable type
LCD-00209: missing value for keyword at end of string [string]
RMAN-08126: keep attributes for the proxy copy are changed
ORA-07471: snclrd: name translation error of sgadef.dbf file name.
RMAN-06561: available space must be larger than number kb
ORA-01644: tablespace 'string' is already read only
ORA-36720: (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.
PLS-00599: SAMPLE percentage must be in the range [0.000001,100)
ORA-09755: osngpn: port allocation failure.
KUP-04078: invalid file name specified: string
Oracle Errors 
