Re: Database not loading

The owner of the tablespace has a system privilege of Unlimited Tablespace.

The tablespace itself:
Inital Size 131072kb
Next Size 65536kb
Minimum Size 131072kb
Increment Size by 50%
Minimum Num 1
Maximum Num Value 2147483645

I have checked all the logfiles on the oracle server and I do not see any that containe any errors.

We are trying something now and if it fails I will post the entire log (it is short) here.

Louis

In article <3a7e73f9$1_at_news.iprimus.com.au>,   "Howard J. Rogers" <howardjr_at_www.com> wrote:
> 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/
> >
>
>

Sent via Deja.com
http://www.deja.com/ Received on Mon Feb 05 2001 - 09:04:39 CST