Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: delete five BIG tables and insert new records on same tables

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

From: Jay <no_at_spam.com>
Date: Mon, 15 Nov 2004 14:15:14 -0500
Message-ID: <cnav2e$gn5$1@msunews.cl.msu.edu>


Yes, Ed, values are different, of course.

append hint was put there for minimize my loggings. Well I might be wrong but I read somewhere that by respecting the nologging keyword, it has less overhead than a
regular insert, and is thus faster.

Thanks
-Jay

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:bbvhp09279csbinlitjs0gbj66bo3i7m3t_at_4ax.com...
> 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:15:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US