| Altering Table with an Indexed Column [message #336165] |
Fri, 25 July 2008 01:32  |
adit_me1
Messages: 49
Registered: October 2007
Location: BANGALORE
|
Member |
|
|
Hi all,
I have a table with a functional index on one of the columns. Now there is a requirement to increase the size of that column. When i try to do so, I get an error saying
ORA-30556: functional index is defined on the column to be modified
I searched Google for the solution and it says that I need to drop the index before altering the table.
Now the table is a huge one with more than 10 million records.
I want to know
1. are their any risks in dropping the index and re-creating it after altering the table?
2. How much time should I expect for this dropping and re-creation of index? I need this approximation as this is going to affect the downtime of my application.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
