RE: Unix script help

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 2 Mar 2004 16:04:02 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA23@USAHM018.amer.corp.eds.com>

Look at:

sqlwhenever clause

better yet to avoid risk of losing the table data

the alter table move command followed by alter index rebuild for each index on table.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of M Rafiq Sent: Tuesday, March 02, 2004 3:07 PM
To: oracle-l_at_freelists.org
Subject: Unix script help

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Mar 02 2004 - 15:01:03 CST