Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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