Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Datafile Crash and PMON error
Try to recover before the 8 Gig boundary.
regards
s.kapitza
orefuja_at_yahoo.com (Segun) wrote in message news:<3eced8bb.0309201219.fb50d6f_at_posting.google.com>...
> I had datafile size problem in Oracle 7.3.4 and I had to extend the
> datafile size involved beyond 8G. Later I had my databse crashed SQL>
> CREATE TABLE gppurseflags2 AS SELECT * FROM gppurseflags;
> CREATE TABLE gppurseflags2 AS SELECT * FROM gppurseflags
> *
> ERROR at line 1:
> ORA-00376: file 261 cannot be read at this time
> ORA-01110: data file 261: 'out of bounds, range = 1 to 200'
>
>
> SQL> select * from <tablename>;
> 2 /
> select * from <tablename>
> *
> ERROR at line 1:
> ORA-00472: PMON process terminated with error
>
>
>
>
> I don't know what to do, I have restored to back to when I had no
> problem and recovered up to when the problem started. The DB could be
> mounted but after it open the error will occur again. Please help me.
>
> Segun
Received on Sun Sep 21 2003 - 01:55:06 CDT