What can cause an Oracle ROWID to change?

by

As you have said, it occurs anytime the row is physically moved on disk, such as:

  • Export/import of the table
  • ALTER TABLE XXXX MOVE
  • ALTER TABLE XXXX SHRINK SPACE
  • FLASHBACK TABLE XXXX
  • Splitting a partition
  • Updating a value so that it moves to a new partition
  • Combining two partitions

If is in an index organized table, then an update to the primary key would give you a different ROWID as well.

More Related Contents:

  1. How do I reset a sequence in Oracle?
  2. ORA-00904: invalid identifier
  3. How can I get column names from a table in Oracle?
  4. Is there any boolean type in Oracle databases?
  5. SQL ROWNUM how to return rows between a specific range
  6. MySQL equivalent of DECODE function in Oracle
  7. SQL recursive query on self referencing table (Oracle)
  8. create table with sequence.nextval in oracle [duplicate]
  9. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  10. Deferrable Constraints in SQL Server
  11. Oracle (Old?) Joins – A tool/script for conversion?
  12. How to populate calendar table in Oracle?
  13. What is it exactly a BLOB in a DBMS context
  14. Does ‘Select’ always order by primary key?
  15. Is there a version control system for database structure changes?
  16. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
  17. How do I list all the columns in a table?
  18. How do you interpret a query’s explain plan?
  19. Oracle DB: How can I write query ignoring case?
  20. How do NULL values affect performance in a database search?
  21. Query a Table’s Foreign Key relationships
  22. Oracle , != , ^= operators
  23. SQL Server equivalent of WM_CONCAT function [duplicate]
  24. ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend?
  25. Removing duplicate rows from table in Oracle
  26. Optimise PostgreSQL for fast testing
  27. DATEDIFF function in Oracle [duplicate]
  28. Pivoting of data using two columns
  29. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  30. Foreign Key Creation issue in Oracle

Leave a Comment