Is there a way to stop a rollback?

I have a table with 10 partitions. Each partition has 1 milion rows. I wanted to delete rows with rid=1, which are in partition 1. It was taking a long, long time. So I killed the session. Now my database is rolled back, all the rows deleted.

Published: 26 Apr 2002

Is there a way to stop the rollback? If I shutdown immediately, I guess it will take a long time to shutdown. If...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

I shutdown abort, when I restart the database, it will do a long, long recovery, right?

I don't care if the data is deleted or not. I need a way to issue "alter table xyz nologging" without triggering the "ORA-00054 resource busy ..."

You can't stop the system from rolling back an aborted transaction. Since you killed the session, the transaction was aborted and the system has no choice but to rollback any changes you made. This system will not decide for you which abort transactions to keep and which to get rid of. So it rolls back all of them. Even if you shutdown the database and bring it back up, it will still perform rollback after the database is started. You'll just have to wait for it to finish. Once it is finished rolling back, you won't get the ORA-00054 error.

Next Steps

What do you think about this answer? E-mail the editors at editor@searchDatabase.com with your feedback.

The Best Oracle Web Links: tips, tutorials, scripts, and more.

Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!

Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.

Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.

Dig Deeper on Oracle database design and architecture

British Rowing selects SAS for data analytics British Rowing, the governing body for rowing and the GB Rowing team, has selected SAS as its official data analytics partner

boot partition A boot partition is a disk partition responsible for holding Windows system files when booting up Windows.

The problem with row-by-row processing in Oracle Database One reader asks what's wrong with his script, and Oracle expert Karen Morton explains the problem with row-by-row processing.

Using a storage partition in your data storage infrastructure Learn about the common use cases for a storage partition in a data storage infrastructure, as well as the differences between a storage partition and a LUN.

eBay's hot/cold-aisle containment in the data center Internet giant eBay uses partitions at the end of its rows of cabinets to help with the hot- and cold-aisle containment in its data centers.

Dual-boot Vista (or XP) and Windows 7--the Easy Way!! While indeed you can shrink the system partition on your current boot/system drive and install Windows 7 on a new partition you create by trimming space from that partition, why bother? You can ...

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Please create a username to comment.

How AI could save the enterprise data catalog

With Vitess 4.0, database vendor matures cloud-native platform

Managing unstructured data is crucial to enterprises' AI goals

Salesforce acquisition of Tableau finally getting real

Tableau analytics platform upgrades driven by user needs

Tableau or Qlik: What separates the data visualization tools?

How to use Qualtrics employee experience tool to gather feedback

SAP partner program strives for long-term relationship with customers

SMBs focus on future with S/4HANA and SAP intelligent enterprise

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

Why AI application development isn't as far away as you think

Microsoft quantum development turns toward hardware

Top 5 options for Linux certifications

New hardware, use cases shape server benchmarking needs

Acquia cloud CMS on AWS, Vista cash flow raise user expectations

Adobe Sign introduces updates targeting mobile device users

Acquia, Drupal founder Dries Buytaert on open source, Vista, CDPs

Discover the key elements of talent management systems

Kronos introduces its latest time clock, Kronos InTouch DX

HRIS department an essential bridge between HR, IT

Next Steps

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.