17.10 - Example: Using ArchiveLoggingObjsV - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

The following SELECT statement displays information about the tables that have online archive active logs and their online archive logging levels. In this example, the logging levels are either T or D (O is also a possible value).

  • T = Online Archive Logging was activated on the table level.
  • D = Online Archive Logging was activated on the database level.
  • O = Nontable objects.
    SELECT databasename, tvmname, loglevel FROM dbc.archiveloggingobjsv;

Result:

DatabaseName      TVMName      LogLevel
---------------   -------      --------
oarc_otop005db1   Tab_nfb      T
oarc_oth007db1    Tab_nfb      D
oarc_oth007db1    tab_fb       D
oarc_otop010db1   Tab_nfb      D
oarc_oth007db1    tab_ppi      D
oarc_otop010db1   tab_nusi     D
oarc_otop016db1   Tab_nfb      T
oarc_oth008db1    Tab_queue    T
oarc_otop010db1   tab_bigcol   D
oarc_otop001db1   Tab_nfb      T
oarc_otop018db1   Tab_nfb      T
oarc_comb002db1   tab_fb       T