the DELETE ALL followed by TABLEUPDATE(1,.T.) did work ... sometimes.
every other time, it would delete the first record, then i would get
a primary key validation error.
so i just switched to SPT to clear out the Oracle table, and stayed
with views to populate it.
thanks.
patrick