Re: LogMiner / Sql Loader Questions

Johne_uk wrote:
> Hi,
>
> Just a quick question on LogMiner.
>
> Basically, I was provided with some table creation scripts and bulk
> data files which were processed with SQL Loader.
>
> I initially executed the create tables scripts and then set all tables
> to NOLOGGING. The reason for this was to reduce redo log activitiy
> when the data was subsequently being loaded and speed things up.
>
> After I had run all the Sql Loader scripts I noticed a large number of
> archive logs had been generated so i decided to examine the contents
> using LogMiner.
>
> All the Operations (for the requisite schema) were listed as
> UNSUPPORTED (no other variations).
>
> Additionally, when I looked at the create table scripts I noticed that
> they included primary key declarations which obviously mean that
> indexes would be created concurrently with the data being loaded and
> possibly some resultant redo activity (indexes therefore not having
> NOLOGGING specified unlike tables).
>
> My question is therefore, what would have caused the redo log activity
> and why are all operations of type UNSUPPORTED ? This is a learning
> exercise for me.
>
> Thanks in advance
> John

http://tahiti.oracle.com
Read about what NOLOGGING does and more importantly does not do. I think you are assuming functionality that does not exist.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org