-- empty seed data delete from PXRCALC; delete from PXREXEM; delete from PXRFSTA; delete from PXRGRAD; delete from PXRADDS; delete from PXRTXCD; delete from NBRRJQE; delete from NBRBJQE; delete from NTRRQUE; delete from NTRBQUE; delete from PTRBDPG; delete from PTRJCRE; delete from PTREHOL; delete from PTRJBLN; delete from NBBPOSN; delete from NTRPCLS; delete from NTRFELD; delete from PTRUSER; delete from NTRSALA; delete from NTRSALB; delete from NTRSGRP; delete from PTRBDFQ; delete from PTRGTAX; delete from PTRCOVR; delete from PTRPREM; delete from PTRLIFI; delete from PTRECBC; delete from PTRECLC; delete from PTREERN; delete from PTRECLS; delete from PTRBREL; delete from PTRDFPR; delete from PTRBCDN; delete from PTRBCAT; delete from PTRBDLD; delete from PTRBDXE; delete from PTRBDXD; delete from PTRBDID; delete from PTRBDCG; delete from PTRBDLG; delete from PTRBDAS; delete from PTRBDPD; delete from PTRBDCA; delete from PTRLVPR; delete from PTRLVAC; delete from PTRLVAS; delete from PTRECLD; delete from PTREARN; delete from PTRLEAV; delete from PTRTREA; delete from PTRLREA; delete from PTRCALN; delete from PTRPICT; delete from PEREEO6; delete from PTREMPR; delete from PTRINST; delete from NTRINST; delete from PTVLCAT; commit; -- copy tables over DB link create database link PDAY connect to username identified by password using 'PDAY'; insert into NTRINST select * from NTRINST@pday; insert into PTRINST select * from PTRINST@pday; insert into PEREEO6 select * from PEREEO6@pday; insert into PTREMPR select * from PTREMPR@pday; insert into PTRPICT select * from PTRPICT@pday; insert into PTRCALN select * from PTRCALN@pday; insert into PTRLREA select * from PTRLREA@pday; insert into PTRTREA select * from PTRTREA@pday; insert into PTRLEAV select * from PTRLEAV@pday; insert into PTREARN select * from PTREARN@pday; insert into PTRECLD select * from PTRECLD@pday; insert into PTVLCAT select * from PTVLCAT@pday; -- insert into PTRLVAS select * from PTRLVAS@pday; insert into PTRLVAC select * from PTRLVAC@pday; insert into PTRLVPR select * from PTRLVPR@pday; insert into PTRBDCA select * from PTRBDCA@pday; insert into PTRBDPD select * from PTRBDPD@pday; insert into PTRBDAS select * from PTRBDAS@pday; insert into PTRBDLG select * from PTRBDLG@pday; insert into PTRBDCG select * from PTRBDCG@pday; insert into PTRBDID select * from PTRBDID@pday; insert into PTRBDXD select * from PTRBDXD@pday; insert into PTRBDXE select * from PTRBDXE@pday; insert into PTRBDLD select * from PTRBDLD@pday; insert into PTRBCAT select * from PTRBCAT@pday; insert into PTRBCDN select * from PTRBCDN@pday; insert into PTRDFPR select * from PTRDFPR@pday; insert into PTRBREL select * from PTRBREL@pday; insert into PTRECLS select * from PTRECLS@pday; insert into PTREERN select * from PTREERN@pday; insert into PTRECLC select * from PTRECLC@pday; insert into PTRECBC select * from PTRECBC@pday; insert into PTRLIFI select * from PTRLIFI@pday; insert into PTRPREM select * from PTRPREM@pday; insert into PTRCOVR select * from PTRCOVR@pday; insert into PTRGTAX select * from PTRGTAX@pday; insert into PTRBDFQ select * from PTRBDFQ@pday; insert into NTRSGRP select * from NTRSGRP@pday; insert into NTRSALB select * from NTRSALB@pday; insert into NTRSALA select * from NTRSALA@pday; insert into PTRUSER select * from PTRUSER@pday; insert into NTRFELD select * from NTRFELD@pday; insert into NTRPCLS select * from NTRPCLS@pday; insert into NBBPOSN select * from NBBPOSN@pday; insert into PTRJBLN select * from PTRJBLN@pday; insert into PTREHOL select * from PTREHOL@pday; insert into PTRJCRE select * from PTRJCRE@pday; insert into PTRBDPG select * from PTRBDPG@pday; insert into NTRBQUE select * from NTRBQUE@pday; insert into NTRRQUE select * from NTRRQUE@pday; insert into NBRBJQE select * from NBRBJQE@pday; insert into NBRRJQE select * from NBRRJQE@pday; insert into PXRTXCD select * from PXRTXCD@pday; insert into PXRADDS select * from PXRADDS@pday; insert into PXRGRAD select * from PXRGRAD@pday; insert into PXRFSTA select * from PXRFSTA@pday; insert into PXREXEM select * from PXREXEM@pday; insert into PXRCALC select * from PXRCALC@pday; commit; drop database link PDAY;