Syntax - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities


where:

SAVED
Deletes the portion of the current journal that has previously been saved with CHECKPOINT JOURNAL.
RESTORED
Deletes the portion of a journal table that was restored from archive for use in a recovery activity.
(dbname)
Name of the database that contains the journal to delete.
ALL
Indicates the operation affects the named database and its descendants.
(dbname.tablename)
Journal table within the named database to delete.
All tables should be distinct within the list. Duplicate tables are ignored.
EXCLUDE
Protects the named journal tables from deletion.
(dbname)
Name of the protected journal table.
ALL
Keyword to protect the named journal and all its descendants.
(dbname1) TO (dbname2)
Alphabetical list of databases to be protected from deletion.
The delimiting database names need not identify actual databases.
Database DBC is not part of a range.