|
Re: ORA-01536: sPACE QUOTA EXCEED FOR TABLESPACE [message #19519 is a reply to message #19518] |
Fri, 22 March 2002 23:48 |
hanu
Messages: 21 Registered: March 2002
|
Junior Member |
|
|
This is happend b'cos, the user has exceeded his limit.
1.You can increase the quota for that user in the tablespace.
2.Create a new tablespace and alter the default tablespace as new tablespace.
3.Add another datafile to the tablespace SYSTEM.
Regards,
Hanu.
|
|
|
Re: ORA-01536: sPACE QUOTA EXCEED FOR TABLESPACE [message #19523 is a reply to message #19518] |
Sat, 23 March 2002 07:51 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
Hi,
As the error says it, the user which wants to create the new table has exeeded his quota for the tablespace used for the creation of this table.
There are two ways to solve this problem:
1) Either you specify an other tablespace when you create your table. Like:
CREATE TABLE table1
( n NUMBER )
TABLESPACE tablespacename
2) You increase the quota for the actually used tablespace. Like:
ALTER user_name QUOTA new_quota_in_mb M ON tablespace_name
To do this you have to be DBA (or the required privileges)
The view USER_TS_QUOTAS describes tablespace quotas for the current user.
HTH Mike
|
|
|