OraFAQ Forum: Server Administration » ORA-01536 space quota exceeded for tablespace 'PRINTCAT'

Home » RDBMS Server » Server Administration » ORA-01536 space quota exceeded for tablespace 'PRINTCAT'

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

ORA-01536 space quota exceeded for tablespace 'PRINTCAT' [message #57338]

Fri, 06 June 2003 08:15

Michele
Messages: 77
Registered: December 2000

Member

Good morning,

I am trying to create a couple of tables in a tablespace. When I look under storage in the OEM tool, I see that I have 200 MG allocated and only 3.4 is used up for this tablespace. However, when I try to create my tables I get the above error message. I am not a DBA but my user has the dba role. In fact, I was the one who created the tablespace orginally using the dbca tool. I guess what is throwing me off is that OEM shows that I do have plenty of space..

Can anyone help me try to resolve? Thanks

Michele

Report message to a moderator

Re: ORA-01536 space quota exceeded for tablespace 'PRINTCAT' [message #57339 is a reply to message #57338]

Fri, 06 June 2003 08:33

Michele
Messages: 77
Registered: December 2000

Member

I was able to fix it with the below command

Alter user User_name quota unlimited on Tablespace_name

Michele :-)

Report message to a moderator

Previous Topic:	Found Dead Server
Next Topic:	Urgent! Oracle 8.1.7 restore on Windows 2000

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 30 17:23:11 CST 2024