Re: Bypassing Rowid?

The rowid is Oracles method of determining where that particular row of data is located on the disk. One is assigned by the Oracle RDBMS for every row in the database. You cannot modify the rowid column. When you use sql*loader in conventional path it will automatically update all the indexes and fire all triggers for every row you insert, but when you use the direct path option it doesn't perform these actions(Although rowid's are still created)

One last point, rowid is not a column in a table. Oracle calls it a pseudocolumn because you can use it to directly access a row for selection and is the fastest method to do so.

Jerra wrote:

> 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 Mon Jun 28 1999 - 09:50:21 CDT