Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Journalling Option
From:   Kambhoji, Naveen Ram Prasanna

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 !!



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020