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: Faster imports

Re: Faster imports

From: Greg Akins <gakinsNOgaSPAM_at_gatewayhealthplan.com.invalid>
Date: Wed, 19 Jan 2000 10:11:51 -0800
Message-ID: <01ebce32.491952ba@usw-ex0105-038.remarq.com>


> Is this a new feature, imports using the nologging attribute?
> Rob.

Not of 'import'

I just issued DDL to alter the table
then ran a PL/sql block

for emprec in select * from table loop
insert into exp_table valeus (emprec.*) ; i := i + 1 ;
if i > 500 then
  commit ;
end if ;
end loop ;
commit ;
end ;

and another ddl to alter table logging.

Received on Wed Jan 19 2000 - 12:11:51 CST

Original text of this message

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