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

On Mon, 15 Nov 2004 13:28:16 -0500, "Jay" <no_at_spam.com> wrote:

>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
>>
>

I assume your 'values' are really different, even though they aren't in your example.

Given that you want to do this on an empty table (freshly truncated or deleted/created or some such) -- what is it you expect to gain from the /* append */ hint? Received on Mon Nov 15 2004 - 13:05:18 CST