Unique index change on custom table
Hi,
I have a custom table in Siebel DB which has multiple indexes, unique as well. I have to change them because we want to partition the table and the oracle error message says the partition index should be a subset of the unique index of the table.
My questions are:
If I change the required unique indexes
- and add the new column to the indexes and press "Apply/DDL" in Siebel Tools, at DB level does the old indexes dropped and build the new ones automatically or there should be done some additional steps? If yes which are these plus steps?
0