Speeple News Search

Sign Up! | Tags | Domains | Statistics | Options | Advanced Search

ORA-01450 During Online Index Rebuild

pythian.com » 2008 » July » 4th » ORA-01450 During Online Index Rebuild

Tagged: oracle, online, internals, indexes, group blog posts, iot, index rebuild, ora 01450

We hit an ORA-01450 error today trying to do online rebuild for an index in an unusable state. This was a non-unique index on a fairly large column — VARCHAR2(800 CHAR). SQL> alter index i1 rebuild online; alter index i1 rebuild online * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01450: maximum key length (3215) exceeded It rang a bell. I remembered that I … Continue Reading »

Latest news from Pythian Group Blog:

  1. Log Buffer #118: a Carnival of the Vanities for DBAs
  2. It’s a Good Time to be Involved with MySQL
  3. Does anybody really know what time it is?
  4. Audit a MySQL Instance with MySQLTuner
  5. MySQL: RENAME TABLE on Transactional Tables Can Jeopardize Slave Data

Latest news from pythian.com:

  1. Reporting from Perth AUSOUG Conference 2008
  2. SQL Server: Understanding and Controlling Connection-Pooling Fragmentation
  3. DBD::mysql on OS X Quirks: Architectures, MySQL Binaries and the Filesystem
  4. MySQL Reference Manual Search
  5. AUSOUG Conference 2008 in Perth — Getting Ready