Jacques,Tanel,Guang Mei,Raj and Mladen, the great
Thanks for all your suggestion and scripts.
What a great list, credit goes to Jared.
Regards Rafiq
From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx> Reply-To: oracle-l@xxxxxxxxxxxxx To: <oracle-l@xxxxxxxxxxxxx> CC: "M Rafiq" <rafiq9857@xxxxxxxxxxx> Subject: RE: Unix script help Date: Tue, 2 Mar 2004 12:20:01 -0800
create table tangram.sw_save nologging tablespace tangram as select * from tangram.sw_use_t_h where sut_closed_dt = (sysdate-10);
declare
n pls_integer ;
begin
select count (*) into n
from tangram.sw_save where rownum < 2 ;
if n = 0
then
raise_application_error (-20010, 'no rows copied') ;
end if ;
end ;
/insert into tangram.sw_use_t_h select * from tangram.sw_save;
> -----Original Message----- > M Rafiq > > I need help for following sql script. I want to put condition before > truncate that table creation must be successful before > truncate runs. The > condition may be to check count before and after creation or > tracking of any > ORA/warning message but I could not make up my mind. I want > to put it in > cron to run it weekly. > > Is any body can help to give me some tips/script itself? > > create table tangram.sw_save nologging > tablespace tangram > as select * from tangram.sw_use_t_h where sut_closed_dt > = > (sysdate-10); > > truncate table tangram.sw_use_t_h; > > insert into tangram.sw_use_t_h > select * from tangram.sw_save; > > commit; > > drop table tangram.sw_save;
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
