Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: count(*) yield ORA-08103

Re: count(*) yield ORA-08103

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sun, 28 Nov 1999 07:29:03 +0100
Message-ID: <943770623.18152.0.pluto.d4ee154e@news.demon.nl>


Yes, though with ordinary tables. In our case this was a corrupt database.

Hth,

--
Sybrand Bakker, Oracle DBA
Deb McCamish <dmccamish_at_columbus.rr.com> wrote in message news:3f204.2038$B66.23511_at_typhoon.columbus.rr.com...
> when i do a count(*) on a freshly loaded partition table, i get:
>
> ORA-08103 object no longer exists
> Cause: The object has been deleted by another user since the operation
> began.
> Action: Remove references to the object.
>
> the table has 104 partitions and 248 million rows.
>
> anyone seen this before?
>
>
>
>
>
>
Received on Sun Nov 28 1999 - 00:29:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US