Re: Performance issue while loading large amount of data

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7032C9FAA_at_lnewton.leeds.lfs.co.uk...
> I can put up with the Bowie references, but surely you missed out one
> line :
>
> SQL> insert into bowie_stuff values ('Laughing Gnome', 1973,
> 'He will never live it down !!');

Not to mention

SQL> insert into bowie_stuff values ('Tin Machine', 1989,  'I could forgive the Laughing Gnome but this is ridiculous');

Of course my collection of Twelfth Night stuff rather suggests that the above falls into the select black from kettle where caller = 'POT' category.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************