Home » RDBMS Server » Security » ora-01950 no privileges on tablespace xxx (9.2.0.8)
ora-01950 no privileges on tablespace xxx [message #396724] Tue, 07 April 2009 17:28 Go to next message
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.
Re: ora-01950 no privileges on tablespace xxx [message #396726 is a reply to message #396724] Tue, 07 April 2009 17:42 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
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?
Re: ora-01950 no privileges on tablespace xxx [message #396727 is a reply to message #396724] Tue, 07 April 2009 17:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10628
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You gave all privs for user MYACCT and creating the table in schema BIMECC_USROWN.
Re: ora-01950 no privileges on tablespace xxx [message #396867 is a reply to message #396727] Wed, 08 April 2009 03:44 Go to previous messageGo to next message
babuknb
Messages: 1731
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
Re: ora-01950 no privileges on tablespace xxx [message #396954 is a reply to message #396727] Wed, 08 April 2009 08:38 Go to previous messageGo to next message
Monica
Messages: 37
Registered: February 2000
Member
Actually I was using the myacct schema. Any suggestions?
Re: ora-01950 no privileges on tablespace xxx [message #396955 is a reply to message #396954] Wed, 08 April 2009 08:41 Go to previous messageGo to next message
Monica
Messages: 37
Registered: February 2000
Member
Thank you. I see my error. Problem solved. Thanks.
Re: ora-01950 no privileges on tablespace xxx [message #397009 is a reply to message #396955] Wed, 08 April 2009 10:58 Go to previous messageGo to next message
babuknb
Messages: 1731
Registered: December 2005
Location: NJ
Senior Member


Thanks
Re: ora-01950 no privileges on tablespace xxx [message #409464 is a reply to message #397009] Mon, 22 June 2009 16:24 Go to previous message
babuknb
Messages: 1731
Registered: December 2005
Location: NJ
Senior Member

Quote:


Monica

Thank you. I see my error. Problem solved. Thanks.


Before responding any request; please read complete thread.


Thanks
Previous Topic: audit usage of procedure in a package
Next Topic: V$PWFILE_USERS is empty
Goto Forum:
  


Current Time: Wed Oct 22 05:26:26 CDT 2014

Total time taken to generate the page: 0.09322 seconds