LogMiner / Sql Loader Questions

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 Received on Tue Feb 13 2007 - 17:18:30 CST