Archives of the TeradataForum
Message Posted: Thu, 29 Sep 2005 @ 21:49:23 GMT
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 !!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|