Archives of the TeradataForum

Message Posted: Tue, 05 Mar 2002 @ 12:04:57 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The SQL:

select tvmnamei
from dbc.tvm
where tablekind='t'
and hashflag <> 'y'
order by 1;

Yields the following:

ACCTG
CHANGEDROWJOURNAL
DATABASESPACE
LOCALSESSIONSTATUSTABLE
LOCALTRANSACTIONSTATUSTABLE
ORDSYSCHNGTABLE
RECOVERYLOCKTABLE
RECOVERYPJTABLE
SAVEDTRANSACTIONSTATUSTABLE
SYSRCVSTATJOURNAL
TRANSIENTJOURNAL
UTILITYLOCKJOURNALTABLE

Paul Johnson.

	<Prev	Next>		<<First	<Prev	Next>	Last>>