Teradata SQL to check whether ONLINE ARCHIVE was enabled or not

select CreateTimeStamp,

DatabaseName (VARCHAR(30)),

TVMName (VARCHAR(30))

from DBC.ArchiveLoggingObjsV;

Comments