Database error (-1562)?

[Greg Matelich]

I tried deleting an attribute from a class. On pressing confirm, I got "***DATABASE ERROR: (-1562) see your database Message Manual." I tried deleting a couple more times. I cancelled, and found the name of the Class name had changed. Now I can't change the name back. The name used to be AUTOMOTIVE. The name was changed (corrupted?) to B0WMLKSDFNLAUTO. I tried to change the name back and got the same 1562 error. After several more attempts the name was changed again, this time to B0WNLZ57LVFXRB0WM. Any ideas what I need to do to fix it? Can I go into Oracle and change the table name there? Where do I get a Message Manual?

[Greg Matelich]

The problem originated in the Oracle database. The change I had attempted to make apperantly exceded the the capacity of the Oracle roll back segment. It then made a temporary copy of the class (hence the generated name). Once our Oracle dba increased all the roll back segments, we were able to rename to temporary class to the original class and was well again.

[Rolf Markstahler]

Hello Greg, following the message from command "oerr ora 1562" as oracle user: 01562, 00000, "failed to extend rollback segment (id = %s)" // *Cause: Failure occurred when trying to extent rollback segment // *Action: This is normally followed by another error message that caused // the failure. Shutdown, restart and then take appropriate action for // the error the caused the failure. If starting up the system // again doesn't solve the problem, it is possible that there is // an active transaction in the rollback segment and the system // can't roll it back for some reasons. Check the trace file // generated by the PMON process for more information. Possibly you can modify the storage parameters of your roll_back segments. Sincerly Rolf