Re: delete five BIG tables and insert new records on same tables

it's an Oracle 8i and it's in Linux box. My inserting scripts are looks like

INSERT /* +append */ into target_table( col1 ,col2 ) VALUES ('241319', '61');
INSERT /* +append */ into target_table( col1 ,col2 ) VALUES ('241319', '61');
INSERT /* +append */ into target_table( col1 ,col2 ) VALUES ('241319', '61');
INSERT /* +append */ into target_table( col1 ,col2 ) VALUES ('241319', '61');

.
.
.

I am thinking of creating csv file to use loader too. Last time, I ran into diskspace problem because of log files.

Thanks.

-Jay

"Mark Bole" <makbo_at_pacbell.net> wrote in message news:uH5md.44325$QJ3.21359_at_newssvr21.news.prodigy.com...
> PC wrote:
>
> > I need to delete five BIG tables and insert new records on same tables.
> > Since it involved lot of computing, it will take long. I'm thinking it
> > will take probably couple of days.
> >
> > What I want is minimal down time, if I have to have little down time.
> > I have sql insert scripts to run.
> >
> > Any suggestions?
> > Thanks.
> > -Jay
> >
> >
> >
> Here's a suggestion: provide more information. Version, platform, what
> exactly do the "insert scripts" do, etc.
>
> Based on what you wrote, just truncate each of the five tables, and run
> your insert scripts. Since your database is up throughout, no downtime.
>
> -Mark Bole
>
Received on Mon Nov 15 2004 - 12:28:16 CST