>I know this is a basic question, but the database is complaining that it
>can't allocate extents while a user trys to update.  How do I do this? 
>I am using Oracle 6 for Netware, and we need more extents asap!
>Thanks!
>john
>============================================================
> John M. Duska                  |  Senior Systems Analyst
> mailto:duska@srfs.pitt.edu     |  Information Resources
> http://www.pitt.edu/~pauj4m    |  University of Pittsburgh
>============================================================

Your tablespace is not large enough to contain the table the user is
using.
What you will need to do is add more space to the tablespace:

ALTER TABLESPACE tablespace_name ADD DATAFILE 'path/filename' SIZE xx;

Substitute the tablespace_name, path, filename, and xx above with the read
values you are using. Size is specified in K or M (5M, 200K, etc).

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: www.arikaplan.com                          <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page Ari Kaplan's Home Page