ITPub博客

First:create table gobo.gobo_om_reservations_2008b asselect * from gobo_om_reservationswhere to_char(CREATION_DATE,'yyyy')<'2008'delete from gobo_om_reservationswhere to_char(CREATION_DATE,'yyyy')<'2008'commitAfter 2009Year:create table gobo.gobo_om_reservations_????b as --????=to_char(sysdate-400,'yyyy') select * from gobo.gobo_om_reservations_2008binsert into gobo.gobo_om_reservations_????bselect * from gobo_om_reservationswhere to_char(CREATION_DATE,'yyyy')<'????'delete from gobo_om