Re: ora-03113 on insert statement into a table

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3CDC37BB.EE09A190_at_exesolutions.com>...
> Arash wrote:
>
> > Hi!
> > For a while our DB is running quite well for the company. Now, today
> > some weird things happened. On trying to enter a new Datarow into a
> > table, I got an ORA-03113. Inserting into all the other tables worked,
> > just this one didnt.
> >
> > A trace-file was created.
> >
> > What I did now, was to dublicate the table and to copy the data from
> > the old table into the new one and deleted the old one.
> >
> > Now everything works well, but why did that happen and might this
> > happen again??
> >
> > thanks in advance, arash.
>
> Questions:
> -------------------------------------------
> 1. What platform?
> 2. What operating system?
> 3. What version of Oracle?
> 4. What is "for a while"? One hour? One week? One month? One year?
>
> Crystal balls cost extra.
>
> Daniel Morgan

Ok, here is some more detailed information:

• Windows 2000 Server
• ORACLE version 8.1.7
• The server was now running for about 4 months.

An Insert-Statement though SQL*Plus already caused the ORA-03113 (as mentioned before).

Any known bugs there?

thanks, arash. Received on Sat May 11 2002 - 07:11:05 CDT