-
ORA-01950: no privileges on tablespace 'USERS'
I am getting an error while adding constraint on a table.
I don't know the password for the table owner. So logged in as SYSTEM and ran the command below.
ALTER TABLE pcx.PCX_PC_TRANS_HISTORY ADD(
CONSTRAINT PK_PCX_PC_TRANS_HISTORY PRIMARY KEY (AS_OF_DATE, OFFICE_CODE, PMS_CODE, TRADE_TYPE, CHNL_CD));
Getting ORA-1950 error.
ALTER TABLE pcx.PCX_PC_TRANS_HISTORY ADD(
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'USERS'
I granted unlimited quota on USERS. Still getting the error.
Any ideas? Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Bookmarks