Archives of the TeradataForum

Message Posted: Thu, 29 Sep 2005 @ 21:49:23 GMT

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

Hi All,

I just want to give a try to the journal option at the table level as we dont have a default journal table at the database level. However when I try to create a table like this I am getting error that test table doesnt exist.

     CREATE TABLE TEST1, no fallback, with journal table=test
                       , no before journal
     (I1 INTEGER unique not null , C1 CHAR,D1 DATE)
     primary index(c1,d1)

When I create test whose structure is similar to that of test1 this statement errors out saying that test is not a journal table. So my question is how to create journal table itself? or how to make the above statement work?

Help in any regards is highly acclaimed !!

Thanks,

Kambhoji.

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