Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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 !!


Thanks,

Kambhoji.



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