Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing huge data
Jay wrote:
>I used
>Alter table target_table NOLOGGING
>and then inserted a record and
>I was able to rollback.
>If NOLOGGING stop logging into redo file.
>how can I rollback?
>
>Should I just use autocommit for my session?
>
>
>Thanks.
>-Jay
>
>
This thread has reached the point where I just have to ask ... how many
tables and how many rows of data. It seems to me that by now more time
has been spent trying to avoid logging than would have been taken to
perform the import in the first place.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue Sep 02 2003 - 18:36:37 CDT