DELETE JOURNAL - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

DELETE JOURNAL removes a journal subtable from the Teradata Database.

where:

 

Syntax Element

Description

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.