Re: Database not loading

Good idea, Stephan -though he would have to have one monster of a PCTINCREASE for it to want a next extent of over 80% of 3Gb!

I wish the guy would include the EXACT error message text. Transcriptions don't wash, at the end of the day.

Regards
HJR "Stephan Langer" <slanger_at_dixi-wc.de> wrote in message news:3A7E7145.15FF7ED1_at_dixi-wc.de...
> hi,
>
> what are the tables pct_increase and next sizes? Can it be they overflow
> (and are rolled back so you don't see it afterwards?)
>
> hth Stephan
>
> mastertivoli_at_my-deja.com schrieb:
>
> > I am not getting an oracle error. I am getting an error in Best/1. The
> > error it is saying is the USERS table is full.
> >
> > When I check all the tables (including system tables) that even have the
> > name user in it I do not find any table that is full. I checked the
> > table space that best/1 is loading in to and it is about 20% full ( out
> > of 3 gig). I also checked the system tables and they are not even
> > close to being filled.
> >
> > My DBA and I are just scratching our heads on this one.
> >
> > Thanks,
> >
> > Louis
> >
> > "Van Messner" <vmessner_at_bestweb.net> wrote:
> > > What's the actual message you get - Oracle error number and the
 message
> > > text?
> > >
> > > <mastertivoli_at_my-deja.com> wrote in message
> > > news:95f56q$jhh$1_at_nnrp1.deja.com...
> > > > I have an oracle 8.1.6 data base on solaris 2.6 that is just
 failing. I
> > > > try to load data in to it and the program doing the load seems to
 run
> > > > for a little while then just dies saying the user table is full.
> > > >
> > > > I have check to the best of my knowledge and my DBA has check and we
 do
> > > > not see any table or table space that is full.
> > > >
> > > > We are not seeing any other messages good or bad to tell us where to
> > > > look. Would any of you have any idea of what I could look check.
> > > >
> > > > If it matters the program doing the load is Best/1 from BMC. It is
> > > > using the oracle 8i client on NT4.0 sp6a to load the db on solaris.
> > > >
> > > > Thanks,
> > > > Louis
> > > >
> > > >
> > > > Sent via Deja.com
> > > > http://www.deja.com/
> > >
> > >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
Received on Mon Feb 05 2001 - 03:35:56 CST