OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Space Quota

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Space Quota [message #63765]

Fri, 05 November 2004 03:51

Michael Bailey
Messages: 8
Registered: February 2001

Junior Member

Hello,

I have been getting the message space quota exceeded for tablespace .......

However I have added a new 1024mb datafile but it's still happening, any idea?

Thanks in advance.

Michael.

Report message to a moderator

Re: Space Quota [message #63767 is a reply to message #63765]

Fri, 05 November 2004 04:55

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You have to allocate more quota on tablespace to the user.

sql> alter user USERNAME quota xx on tablespace_name;
or
sql> alter user USERNAME quota UNLIMITED on TABLESPACE_NAME;

Report message to a moderator

Re: Space Quota [message #63768 is a reply to message #63767]

Fri, 05 November 2004 04:58

Michael Bailey
Messages: 8
Registered: February 2001

Junior Member

What if there is no entries on the dba_ts_quota table?.

Can I still do this

Report message to a moderator

Re: Space Quota [message #63772 is a reply to message #63768]

Fri, 05 November 2004 05:29

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

If you are sure about the space quota is exceeded,
Ora-1536 "space quota exceeded for tablespace '%s'
You can do this.
If the message is like ' unable to extend tablespace' you needd to add more datafiles.
IF above is not helping, Post the complete error message

Report message to a moderator

Previous Topic:	Create rollback segment error while importing
Next Topic:	Location of Oracle alert log in diferent versions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 22:43:38 CST 2025