Re: Help! we have errors ORA-10117

In article <01bc1200$6b6c7060$63c9fbb6_at_Bob_Ryan.seatimes.com>, Bob Ryan <brya-ele_at_seatimes.com> writes
>We have an older version of oracle on a system we know little about.
>I believe the oracle version is 5.something.
>The database is on a vax vms system and we have no documentation on this
>error code.
>
>Is there anyone who can tell me what to do about this error code?
>
>Thanks in advance.
>Bob Ryan

I seem to remember that in version 5, recursive SQL errors added 10,000 to the error code. This means that your actual error is ORA-0117, and it happened during a recursive call (that is a call to some sql function by the kernel to satisfy your sql request). By an amazing coincidence, I happen to have an Oracle 5.1 errors and codes manual here.

ORA-0117 is 'cannot create extent, no more space in system partition'.

This means that one of the data dictionary tables tried to expand and couldn't. You need to expand your system partition. I can't remember the syntax for doing so in version 5 (I'm not even sure you can do it),but I do remember that on VMS, you have create oracle data files in advance by running something like 'ccf' which stands for 'create contiguous file'.

The alternatives are -

delete anything in the system partition which shouldn't be there

do a full export, re-create your database with a larger system partition and re-import.

Hope this helps.

ps.

You really should upgrade, Oracle have stopped supporting version 6 never mind 5.

-- 
Jim Smith