Home » SQL & PL/SQL » SQL & PL/SQL » Altering Table with an Indexed Column (
Altering Table with an Indexed Column [message #336165] Fri, 25 July 2008 01:32 Go to next message
Messages: 49
Registered: October 2007
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.
Re: Altering Table with an Indexed Column [message #336179 is a reply to message #336165] Fri, 25 July 2008 02:18 Go to previous message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Of course there is always a risk but don't you have to do it anyway? So you have to assume the risk

2. 10 million is small, test it on a test db.

Previous Topic: Date range SQL CURSOR
Next Topic: Optimize the query
Goto Forum:

Current Time: Mon Aug 21 08:54:24 CDT 2017

Total time taken to generate the page: 0.06655 seconds