Re: bypass rollback for large insert statements

Hy

I think you are talking about using the direct path loading, if this is true you need to use the append HINT as shown into the following code block:

INSERT /*+append */ INTO table_name (....) SELECT (...) FROM table_name

or furthermore you can use the clause NOLOGGING to avoid writing redo information to the redo log buffer:

INSERT /*+append */ INTO table_name (....) NOLOGGING SELECT (...) FROM table_name

Hope this helps

Ciao Gennaro

jim shorts wrote:

> I have an application that is updating a very large Oracle 7.3.4
> database. at the end of the application are some insert statements that
> affect about 100K rows of data. i've tested the statements and I'm sure
> they complete successfully. I'm trying to find out if their is a clause
> I can add to the insert statements that will bypass the rollback
> segments and just update the database. For example:
> insert into tablename (col1, col2, col3) values (data, data+1, data)
> norollback;
>
> any input would be greatly appreciated. thanks.
Received on Fri Jun 23 2000 - 00:00:00 CDT