17.00 - Example: Using ArchiveLoggingObjsV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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