Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-13362: disjoint sub-element in a compound polygon

1 Answers  


ORA-29360: retry operation. Too much concurrent activity

1 Answers  


ORA-13138: could not determine name of object string

1 Answers  


LRM-00120: 'string' is not a legal Oracle number for 'string'

1 Answers  


ORA-39018: master process received invalid message number string

1 Answers  


ORA-00024: logins from more than one process not allowed in single-process mode

1 Answers  


ORA-31445: invalid lock handle while acquiring lock on string

1 Answers  


PLS-00543: a PLSQL Table may not contain a nested table type or VARRAY.

1 Answers  


PROC-00105: Logging error

1 Answers  


ORA-24403: error occured while trying to destroy the connection pool

1 Answers  


PLS-00737: LIBRARY file specification exceeds the maximum allowed length

1 Answers  


DRG-11711: too much data for term string

1 Answers  


Categories