deleting and shrinking journals

hi dexter,

Please before you always do anything make sure to know what you are doing, the first statement is so far good no problem it will delete the data from the journal table when you use the delete statement.

but the sec> I deleted journal using this statement- delete from journal where [time]

attn: Akber

how do i shrink the table journal. only my receipts are gone. everything else is fine.

Dexter

"Akber Alwani" wrote: