Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Faster imports
> 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.