Understanding oracleROWID

Understanding oracle ROWID the The data is stored in the data file, and its attributes will be determined along with the storage. These attributes include: which data file? Which object does it belong to? Where is the data block located? line number? Combining these attributes constitutes the oracle ROWID. the Therefore, the rowid records the location of the data on the disk in detail. www.2cto.com ROWID can be divided into: physical and logical. Except IOT uses logical ROWID, other types of tables use physical ROWID. ROWID can also be divided into: restricted and extended. After 8i use extended rowid. The following introduces the extended rowid. Extended rowid, using 64-bit encoding, press 6, 3 to open. example: [sql] SQL> show user USER is “HR” SQL> drop table t1 purge; drop table t1 purge * * Error on line 1: ORA-00942: table or view does not exist the SQL> create table t1 (id number,name varchar2(20)); the The table has been created. the www.2cto.com SQL> insert into t1 values(1,'a'); the It has created a row. the the SQL> insert into t1 values(2,'b');  the It has created a row. the the SQL> commit; the Commit complete. the the SQL> select rowid,t1.* from t1; the…