How to Restore a Database After a Failed ABORT Request | Basic Teradata Query - Restoring a Database After a Failed ABORT Request - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-11-15
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
lifecycle
latest
Product Category
Teradata Tools and Utilities
If the request did not affect the database, or if the affect was not damaging, then the impact of a failed abort request is minimal. If the request damaged the database, then correct the damage using one of the following options:
  • If the request was embedded in a transaction, abort the transaction by submitting an SQL ABORT statement as a normal SQL request, which backs out the effect of the damaging request.
  • If the request was not embedded in a transaction, submit a second request that has the opposite effect of the first, thus returning the database to its state before the damaging request.