OraFAQ Forum: Security » ora-01950 no privileges on tablespace xxx

Home » RDBMS Server » Security » ora-01950 no privileges on tablespace xxx (9.2.0.8)

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

ora-01950 no privileges on tablespace xxx [message #396724]

Tue, 07 April 2009 17:28

Monica
Messages: 37
Registered: February 2000

Member

I am trying:
CREATE TABLE BIMECC_USROWN.MECC_DASH_PNS
(
F_PRODUCT_NAME VARCHAR2(40 BYTE) NOT NULL,
PRODUCT_NAME VARCHAR2(40 BYTE) NOT NULL,
MFG_SEQ NUMBER(3) NOT NULL,
SLIFE_FLAG VARCHAR2(1 BYTE)
)
TABLESPACE BIMECC_IND_SMALL
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
/

I get ORA-01950 no privileges on tablespace error.

I am logged in as sys or as myacct with dba privs.

I have tried:
ALTER USER myacct QUOTA unlimited ON bimecc_ind_small;

GRANT RESOURCE TO myacct;

alter user myacct quota unlimited on bimecc_ind_small;

I still cannot create the table.

Report message to a moderator

Re: ora-01950 no privileges on tablespace xxx [message #396726 is a reply to message #396724]

Tue, 07 April 2009 17:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.

It appears to be a mystery.

Do you get different results if you logout (EXIT) as user myacct
& then login again before try CREATE again?

Report message to a moderator

Re: ora-01950 no privileges on tablespace xxx [message #396727 is a reply to message #396724]

Tue, 07 April 2009 17:43

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You gave all privs for user MYACCT and creating the table in schema BIMECC_USROWN.

Report message to a moderator

Re: ora-01950 no privileges on tablespace xxx [message #396867 is a reply to message #396727]

Wed, 08 April 2009 03:44

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

CREATE TABLE BIMECC_USROWN.MECC_DASH_PNS
(
F_PRODUCT_NAME VARCHAR2(40 BYTE) NOT NULL,
PRODUCT_NAME VARCHAR2(40 BYTE) NOT NULL,
MFG_SEQ NUMBER(3) NOT NULL,
SLIFE_FLAG VARCHAR2(1 BYTE)
)

ALTER USER myacct QUOTA unlimited ON bimecc_ind_small;

GRANT RESOURCE TO myacct;

alter user myacct quota unlimited on bimecc_ind_small;

Are you feel any difference.

Babu

Report message to a moderator