Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: table space problem
jas888_at_my-deja.com wrote<83a4cp$dvc$1_at_nnrp1.deja.com> ...
>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'. "
>
This message occurs because of USER, who currently connected to server, does
not have enough QUOTA for this tablespace, not because of tablespace size is
not enough.
To change the USER quota for tablespace USERS:
alter user <user_name> quota {unlimited|size} on USERS
>Also, does increasing the tablespace greatly slow down the system's
>database performance ?
no - this operation is only reserved place for future
Ayc Received on Thu Dec 16 1999 - 03:31:31 CST