Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 8i truncate
Oracle 8i truncate [message #35866] Sat, 20 October 2001 03:36 Go to next message
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

----------------------------------------------------------------------
Re: Oracle 8i truncate [message #35871 is a reply to message #35866] Sat, 20 October 2001 16:33 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
export that table..

----------------------------------------------------------------------
Re: Oracle 8i truncate [message #37871 is a reply to message #35866] Mon, 04 March 2002 11:09 Go to previous message
Lonnie C. Spears
Messages: 2
Registered: March 2002
Junior Member
Truncate does not fire the delete trigger.

To move the data for truncate, you'd have to do so programmatically.

Lonnie C. Spears
Kiretsu Technology, Inc.
lspears@kiretsutech.com
Previous Topic: Compile sechema Error
Next Topic: Date conversion
Goto Forum:
  


Current Time: Thu Mar 28 13:50:20 CDT 2024