Archives of the TeradataForum

Message Posted: Thu, 29 Sep 2005 @ 22:47:21 GMT

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

<-- Anonymously Posted: Thursday, September 29, 2005 18:19 -->

Before you can create a table that uses a Journal table, you must first create the journal table. You can only create one journal table per database but you can have many tables from different databases use that Journal Table. The easiest way to create a journal table is to create it when you create the database as follows.

     CREATE DATABASE prod_jrnl_db from dbowner  AS
     PERMANENT = 1000000
     SPOOL = 1000000
     TEMPORARY = 0
     ACCOUNT = 'DBC'
     NO FALLBACK
     NO BEFORE JOURNAL
     NO AFTER JOURNAL
     DEFAULT JOURNAL TABLE = prod_jrnl_db.jrnl01;

----This SQL will list the Journal tables that exist on your system.

     select * from dbc.tables
     where tablekind = 'J'
     order by databasename;

Before using Journal tables I'd suggest thoroughly reading the Teradata documentation on them. They can be difficult to use and add complexity to your restores.

Hope this helps.

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