PL/SQL trigger fires once a day

I am creating a table of appointments. As this table is going to get very large very quickly, I want to move the old appointments into a backup table, backupAppointments. How do I do this using a trigger? I have got this so far:

create or replace trigger cleanAppointments after insert on appointments
when apoointments.date < SYSDATE
Begin
-- move the records
End;

Any help would be greatly appriciated. Received on Sun Feb 08 2004 - 05:48:23 CST