Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01640: cannot make tablespace read only with active
transactions
- 1 Answers
- 4111 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-13227: SDO_LEVEL values for the two index tables do not match
ORA-06035: NETDNT: connect failed, insufficient resources
TNS-00042: INTCTL: CMANAGER already running. Start operation cancelled
ORA-01200: actual file size of string is smaller than correct size of string blocks
ORA-22343: Compilation error for type invalidated by ALTER TYPE
ORA-12463: undefined group string for policy string
ORA-30025: DROP segment 'string' (in undo tablespace) not allowed
ORA-22306: type "string"."string" already exists
RMAN-08155: printing stored global script: string
ORA-24900: invalid or unsupported mode paramater passed in call
ORA-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
ORA-28271: No permission to read user entry in LDAP directory service.
Oracle Errors 
