Syntax - 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.