Re: Bypassing Rowid?

From: Mark Gumbs <mgumbs--AT--hotmail.com>
Date: Fri, 14 May 1999 15:15:56 +0100
Message-ID: <373c2e01.0@145.227.194.253>

You only bypass all triggers etc with SQL*Loader when using direct path (direct=true).
Unless someone knows otherwise, you cannot put data in a rowid column. Rowid is a 'pseudo column' which is internal to an oracle table. Rowid normally maps to the physical location of the data on disk so i can't see the login in wanting to write something to it anyway.

Mark

Jerra wrote in message <373C2CA5.FB72A091_at_consilia.aland.fi>...
>I thought that by loading data with sql*loader you bypassed all triggers
>and rowid etc, just stuffing the database with bulk-data.
>Apparently it's not. So how do I do? I want to insert data in RowId
>columns . Oracle does not like that naturally, but there must be a way
>to do it.
>
>Any help greatly appreciated!
>Regards
>Jerra
>
Received on Fri May 14 1999 - 09:15:56 CDT