Re: table space problem
From: Alexander Chuchko <ayc_at_feature.kharkov.ua>
Date: Thu, 16 Dec 1999 11:31:31 +0200
Message-ID: <3858b21b_at_newsfeed.itl.net.ua>
Date: Thu, 16 Dec 1999 11:31:31 +0200
Message-ID: <3858b21b_at_newsfeed.itl.net.ua>
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 - 10:31:31 CET