Same ROWID in Oracle Clustered Tables
Oracle ROWID is said to be unique within a table, but they can overlap with other tables especially in the case when tables are in a cluster. I am trying to understand on how would two tables in a cluster end up having the same rowid given the fact that last three characters in the rowid format have a row number attached to it.
Is this because the records from both the tables are being stored in the same row with the cluster key columns? Taking an example of employee and department and the cluster key being dept_no, because the rows of employee and department are stored as prejoined, is that leading to some of the employee and department rows having the same row id? i.e. column values of employee table (emp_name, emp_address, joining date) and the department table (dept_name, dept_head) are stored in the same row with the cluster key (dept_id).