Re: ORA-1654 What is it?

In article <43cl3k$66q_at_grandcanyon.binc.net> Dave Wieneke <dwieneke> writes:

> A client of ours got an ORA-1654 error. According to our manuals, it is
> undocumented. Has anyone run into this? What is the problem.

It's far from being undocumented...

% oerr ora 1654
01654, 00000, "unable to extend index %s.%s by %s in tablespace %s"

// *Cause:  Failed to allocate an extent for index segment in tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
//         files to the tablespace indicated.

Hope this helps

--
 "Everything that can be said about Win95 has been said... The Win95 user
  interface is not nearly as good as the Mac.  Blah, blah.  It has all been
  said a thousand times." - Larry Ellison

 Alvin W. Law ........................................... Oracle Corporation
 Senior Technical Consultant ................ 300 Oracle Parkway, Box 659305
 Applications Design & Architecture ............... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ...... Voice: +1.415.506.8317 . Fax: +1.415.506.7294