Re: table space problem

Jason,

the tablespace quotas for the db-user who performs the action exceeded. The quotas are recorded in table DBA_TS_QUOTAS (select * from DBA_TS_QUOTAS;) You can extend these quotas with the following command:

alter user <username> quota <size>/unlimited on <tablespace_name>;

i.e.:
alter user miller quota 20M on users;
or
alter user miller quota unlimited on users;

I don\'t know how you increased the tablespace:\'alter tablespace add datafile ...\' or \'alter database datafile resize\' - the second way ist the better (more perfomant) way (max. size is 2GB). By the way, the best method to increase performance (regarding tablespaces) is to distribute r/w access equally over several disks.

kind regards
Hartmut

> Hello folks,
>
> I have created a web site that keep appearing at the end of each page.
>
> \"An Unhandled Exception has occurred ORA-01536: space quota exceeded
> for tablespace \'USERS\'. \"
>
> As a result, I increased the table space for \"USERS\" for another 400Mb.
> It registered correctly when I check monitor tablespace for USERS in
> which only 7% are being used.
>
> But for this particular site, the error keep appearing. Any way to stop
> the occurances for this error ?
> Also, does increasing the tablespace greatly slow down the system\'s
> database performance ?
>
> Regards
> Jason
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Thu Dec 16 1999 - 11:58:19 CET