Re: Storage problems with Oracle Blobs.

Hi,

Firstly thanks for your responses.

I have resolved the issue but would appreciate it if you could give me a understanding of why this is an issue.

As detailed in my first post there are two users involved, the first user has the same name as the table schema and is the user I used to create the schema with. When the schema was created the user had the SYSDBA role, subsequently the SYSDBA role has been removed from the user.

When I run my software that adds rows to the table I connect with another user which has the SYSDBA role. When I add a row to the table that contains a blob data field I get the follwing error: [Oracle] [ODBC][Ora]ORA-01536: space quota exceeded for tablespace 'USERS'.

Granting the UNLIMITED TABLESPACE system privilege to the user who created the schema resolves the issue.

I do not understand why the quota system should be using quota space from the schema owner, shouldn't it be using the quota space from the user who is inserting the data ???

I look forward to your thoughts.

Regards, Jon. Received on Wed Dec 05 2007 - 09:48:23 CST