Archives of the TeradataForum
Message Posted: Wed, 13 Aug 2003 @ 14:05:23 GMT
| Subj: | | Re: Renaming table |
| |
| From: | | David Wellman |
Sankar,
If you want to backup whilst also updating thetable, use Perm Journals - After Image - and use the GROUP READ LOCK option on the Archive
job. This should give you what you want.
Incremental backups have been asked for by many people, but to implement that requires that the DBMS keeps track of every row that gets
added or updated. Do you want an 8-byte timestamp added to every row on your table? May be it could be done at the Cylinder level, but as a
Teradata cylinder only holds about 1.8MB of data then would you save that much? As with the "rename across databases" this could no doubt
be implemented but I think you'd end up using a considerable amount of additional space and processing cycles to maintain the list of
'changed rows'.
Just my two pennies worth.
Dave
| 
