Home » SQL & PL/SQL » SQL & PL/SQL » Altering Table with an Indexed Column (10.2.0.3)
Altering Table with an Indexed Column [message #336165] Fri, 25 July 2008 01:32 Go to next message
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.
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: 64111
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.

Regards
Michel
Previous Topic: Parallel Full Partition Scan
Next Topic: BULK COLLECT VS CURSORS
Goto Forum:
  


Current Time: Mon Dec 05 21:14:01 CST 2016

Total time taken to generate the page: 0.09486 seconds