OraFAQ Forum: SQL & PL/SQL » Procedure/script to move selected data into an archive table

Home » SQL & PL/SQL » SQL & PL/SQL » Procedure/script to move selected data into an archive table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Procedure/script to move selected data into an archive table [message #35727]

Wed, 10 October 2001 11:57

Trevor Pearson
Messages: 5
Registered: October 2001

Junior Member

Does anybody have a procedure or script to move selected data from one table into an archive table of the same structure? For instance, all data inserted after a certain date?

----------------------------------------------------------------------

Report message to a moderator

Re: Procedure/script to move selected data into an archive table [message #35729 is a reply to message #35727]

Wed, 10 October 2001 12:21

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

If the structures of the two tables are identical, then you can simply:

insert into archive_table
select * from source_table
where tran_date >= :somedate;

delete from source_table
where tran_date >= :somedate;

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Re: ORA-00600: internal error code, arguments: [15267], [223], [], [], [], [], [], []
Next Topic:	Printing variables in html forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 20 07:48:14 CDT 2025