Oracle 8i truncate [message #35866] |
Sat, 20 October 2001 03:36 |
Milan Kumar Barui
Messages: 16 Registered: October 2001
|
Junior Member |
|
|
Hi,
I have got a big table in oracle 8i database. In regular interval I truncate that table. But I want the data in this table to be shifted to other table or other database for backup whenever I truncate. I can do this with delete trigger. But that will be very slow. Is there any method to do this for truncate case?
Milan
----------------------------------------------------------------------
|
|
|
|
|