Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot grant quota on tablespace

500583Mar 22 2006 — edited Feb 15 2011

Hi,

I am trying to grant unlimited quota to a temporary tablespace with following command:

CREATE USER "TRANSFORM" IDENTIFIED BY "SECRET" DEFAULT TABLESPACE "TRANSFORM" TEMPORARY TABLESPACE "TRANS_TEMP" QUOTA UNLIMITED ON "TRANSFORM" QUOTA UNLIMITED ON "TRANS_TEMP";

This fails with the error: ORA-30041: Cannot grant quota on the table space.

If I remove QUOTA UNLIMITED ON "TRANS_TEMP" from the SQL then it runs correctly.

Exactly the same thing happens if I try and manually add the user via Enterprise Manager (i.e. The sql it automatically builds is incorrect).

Can someone confirm that you cannot create quota on temporary tablespaces in Oracle 10g Rel 2.

Regards,

Paul.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2011

Added on Mar 22 2006

#general-database-discussions

11 comments

37,066 views