Archives of the TeradataForum

Message Posted: Fri, 12 Jul 2002 @ 03:15:46 GMT


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

Subj:		Re: Archiving Resusage Tables

From:		Bergman, Ysbrand

Hi Ruth,

I think you've overlooked AccessRights as well.

So to summarize the all 14 tabels that are included in an archive:

AccessRights - Specifies all granted rights.

AccLogRuleTbl - Defines access logging rules generated by executing BEGIN/END LOGGING statements.

Accounts - Lists all authorized account numbers.

CollationTbl - Defines MULTINATIONAL collation.

DBase - Defines each database and user.

Hosts - Defines information about user defined character sets used as defaults for client systems.

LogonRuleTbl - Defines information about logon rules generated by a GRANT LOGON statement.

Next - Generates table, stored procedure, and database identifiers (internal table).

Owners - Defines all databases owned by another.

Parents - Defines all parent/child relationships between databases.

RCEvent - Records all archive and recovery activities.

RCConfiguration - Records the configuration for RCEvent rows.

RCMedia - Records all removable devices used in archive activities.

Translation - Defines hexadecimal codes that form translation tables for non-English character sets.

Regards,

Ysbrand

Ysbrand Bergman
Support Specialist
EMEA RTS
Teradata a division of NCR


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