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);
insert into tangram.sw_use_t_h select * from 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 -----------------------------------------------------------------