2

Oracle documentation says Columns defined using the ROWID data type behave like other table columns: values can be updated, and so on.

Can I create a index on a column defined using ROWID data type containing rowids ?

Bolimera Hannah
  • 195
  • 1
  • 2
  • 11

1 Answers1

1

Oracle must be right. Yes, you can.

SQL> CREATE TABLE rowid_test (c_rowid ROWID);
Table created
SQL> CREATE INDEX rowid_test_idx ON rowid_test(c_rowid);
Index created
Andris Krauze
  • 2,092
  • 8
  • 27
  • 39