ORA_01536:Space Quota exceeded for tablespace 'USERS'

[masiwan]

I get this error when I try to put a primary key to my table. How can I resolve this error ?. The table was created long ago but now I want to use one of the columns as a primary key, so I open the table design, use the Constraints tab to define my primary nkey, when I click on the Apply button this error comes

 

[SantaMufasa]

Masiwan,

When you declare a column to become a new Primary Key, Oracle's response is to create a new UNIQUE INDEX for that Primary Key column. That index, depending upon the combined widths of each Primary Key value, could consume gigabytes of space.

Therefore, to get past your problem, you must ask your DBA to:

ALTER USER <your username> QUOTA {UNLIMITED | <some value>} ON USERS;

Let us know how this worked for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[Turkbear]

Hi,
We, as a matter of practice, use separate tablespaces for Data and Indexes...Not required ( although it does allow for separate default storage params), but helps in keeping things organized..





To Paraphrase:"The Help you get is proportional to the Help you give.."