Re: Problem with Oracle database

Sandy Goertemiller wrote:
>
> We have an Oracle 7.3.3.2 database. Every day we delete entries from the
> table and reload. After a few weeks the table gets corrupted and we start
> getting an Oracle 600 error when we try to do a select. If I drop the
> table and recreate then reload the data, the problem goes away.
>
> Does anyone have any suggestions as to what I should look at? Could there
> be something in my delete or insert that is a problem? The delete is
> basically "Delete where id = '1070'", where the value of id changes. Then
> new records for id 1070 are loaded.
>
> I appreciate any ideas or suggestions as to what I could look at to resolve
> this issue.
>
> Thanks,
> Sandy Goertemiller
> scgoertemiller_at_scripps.com

Any additional information would be useful (especially the first number in square brackets following the ora-00600 error), what tool you were using to load the data with (ie; sqlldr, Pro*C, MS toys) and what platform your database and tool running on. Has the database been restarted between loads? Have you checked to determine if it was the table or index that may have been corrupted (analyze object objectname validate structure)? Have you also check your alert log and trace files. Any useful information there?

Hope some of my questions help locate the problem, if not then supply me (and others) with more info.

Thanks,
Greg... Received on Mon Aug 18 1997 - 00:00:00 CDT