Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which three steps are necessary before you can take a tablespace offline that contains active rollback segments?

April 26, 2017active necessary offline Rollback segments steps tablespace

0

Posted

Which three steps are necessary before you can take a tablespace offline that contains active rollback segments?

1 Answer

0

Posted

Before you can take a tablespace with active rollback segments offline: Query DBA_ROLLBACK_SEGS to determine which rollback segments are in the tablespace and take the rollback segments offline. Query V$TRANSACTIONS to determine the transaction currently using the rollback segments. Query V$SESSION to determine the user with the pending transaction and terminate their session.