Re: Where can I find the description of an ORA Error number !!

After you register at technet.oracle.com, you can view the messages at http://technet.oracle.com/doc/oracle8i_816/server.816/a76999/toc.htm Obviously you can also install documentation on your local computer.

On UNIX, you can type oerr ora 1654.

On NT, you can use my program Windowsoerr (The Web site hosting my Web page is down till next week but the URL is
www.stormloader.com/yonghuang/Windowsoerr.html) This program is based on locally-installed Oracle documentation.

Finally, you can:
set serveroutput on
begin
dbms_output.put_line(sqlerrm(-1654));
end;
/
But this method is close to useless because it usually doesn't give you more detailed info and is limited to the ORA facility.

Yong Huang
yhuang_at_indigopool.com

Kevin LEE <klee_at_esec.com.au> wrote in message news:39BD83CE.2DC572D1_at_esec.com.au...
> Hi all:
>
> I have the following error mesg from the oracle database:
>
> ORA-01654: unable to extend index KLEE.SYS_C001410 by 315 in tablespace
> SYSTEM
>
> I suspect the above erreor is due to my table is reached to it full
> size and cannot accept any new data.
>
> I want to known where can I find the exact description of ORA-01654: on
> line ???
>
> Thanks,
> Kevin
>
>
> --
> --------------------------------------------------------------------------
> Kevin LEE
> Software Architect - Security Management Service
> eSec Limited
> "Protecting Your e-Business"
>
> Tel: +61 3 8371 5300
> +61 3 8371 5378 (direct)
> Fax: +61 3 8371 5339
> Web: http://www.esec.com.au
> --------------------------------------------------------------------------
>
>
>
Received on Tue Sep 12 2000 - 14:49:45 CDT