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