Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 Dec 2003 @ 12:53:47 GMT


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


Subj:   Netvault & catalog table
 
From:   Chamoun Jabbour

Hi all,

As you can see in the $NETVAULT_CATALOG database, the catalog table grows all the time and there is no column relating to the time (date, timestamp, ...etc). In order to maintain this table do you have any idea how we could purge or delete information without having a problem with Netvault?

Any suggestions?


Thanks,

Chamoun


Columns of catalog table

EVENTNUM INTEGER NOT NULL,
SEQNUM INTEGER NOT NULL,
OBJLEVEL CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
TVMKIND CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
TABLEPROTECTION CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
DATABASENAME VARCHAR(30) CHARACTER SET LATIN CASESPECIFIC NOT NULL,
TABLENAME VARCHAR(30) CHARACTER SET LATIN CASESPECIFIC NOT NULL,
POSTYPE CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
REPOSITIONINFO VARBYTE(256)



     
  <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