ROWID

Posted on June 8th, 2008 by admin

 

Oracle uses a ROWID datatype to store the address (rowid) of every

row in the database.

Physical rowids store the addresses of rows in ordinary tables

(excluding index-organized tables), clustered tables, table

partitions and subpartitions, indexes, and index partitions and

subpartitions.

Logical rowids store the addresses of rows in index-organized tables.


Add your opinion - this will move the pointer
get dashboard plugin?

Filed under: DBA (DataBase Administrator), ERP, PL/SQL, SQL

Free Dashboards

Here are some more interesting Articles
  • UROWID

    • Leave a Reply

    You must be logged in to post a comment.

    « SGA data Structures - Shared Pool portion of the SGA Trace Files and the Alert Log-LGWR »

    • About InfoPurple

      InfoPurple is an Oracle Digest that collects best articles from the best minds from entire blogosphere. We collect them and post an excerpt and point back to the main site. This allows for a consolidated view of Oracle Apps related topics. If you would like to add your website to be included then please email us (infopurple8888 AT gmail DOT com) your web url. If you would like to get your website removed then send us an email and we will remove it. -- infoK purple