yep the rowid changes
Code:Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options JServer Release 9.2.0.5.0 - Production SQL> create table t (dummy varchar2(20)); Table created. SQL> insert into t values ('1'); 1 row created. SQL> commit; Commit complete. SQL> select rowid from t; ROWID ------------------ AAAMYNAABAAAJ5CAAA SQL> alter table t move; Table altered. SQL> select rowid from t; ROWID ------------------ AAAMYOAABAAAJ5KAAA (slight change) SQL> alter table t move tablespace libra_data; Table altered. SQL> select rowid from t; ROWID ------------------ AAAMYPAAVAAAEbsAAA (bigger change)




Reply With Quote