WHENEVER SQLERROR EXIT will do nicely. On 03/02/2004 03:07:09 PM, M Rafiq wrote: > Hi > > 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? > > Regards > Rafiq > > > 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; > > _________________________________________________________________ > Frustrated with dial-up? Lightning-fast Internet access for as low as > $29.95/month. http://click.atdmt.com/AVE/go/onm00200360ave/direct/01/ > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------