Home » RDBMS Server » Server Utilities » ORA-01950: no privileges on tablespace (Oracle 10.2.0.4.0,windows)
ORA-01950: no privileges on tablespace [message #546877] Fri, 09 March 2012 10:10 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,
I get error message during import.Please find the below error.

IMP-00017: following statement failed with ORACLE error 1950:
 "CREATE TABLE "DEMO" ("MFG_ID" NUMBER(10, 0) NOT NU"
 "LL ENABLE, "MFG_PART_NBR" VARCHAR2(20 BYTE) NOT NULL ENABLE, "AAIA_VEHICLE_"
 "ID" NUMBER(10, 0) NOT NULL ENABLE, "AAIA_CATEGORY_CD" VARCHAR2(10 BYTE) NOT"
 " NULL ENABLE, "AAIA_SUBCATEGORY_CD" VARCHAR2(10 BYTE) NOT NULL ENABLE, "PAR"
 "T_DESC" VARCHAR2(60 BYTE), "PART_NOTE" VARCHAR2(4000 BYTE), "ADD_DEL_IND" V"
 "ARCHAR2(1 BYTE), "REFERENCE_DT" DATE NOT NULL ENABLE)  PCTFREE 20 PCTUSED 7"
 "0 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 52428800 NEXT 52428800 MAXEXTENTS"
 " 505 PCTINCREASE 0) TABLESPACE "CATALOG_TEMP" LOGGING PARTITION BY RANGE (""
 "AAIA_VEHICLE_ID" )  (PARTITION "CPAD01" VALUES LESS THAN (1040000)  PCTFREE"
 " 20 PCTUSED 70 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 1999634432 FREELISTS"
 " 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "CATALOG_COMP_PARTAPPL"
 "_DATA_01" LOGGING NOCOMPRESS, PARTITION "CPAD02" VALUES LESS THAN (1080000)"
 "  PCTFREE 20 PCTUSED 70 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 2087714816 "
 "FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "CATALOG_COMP"
 "_PARTAPPL_DATA_02" LOGGING NOCOMPRESS, PARTITION "CPAD03" VALUES LESS THAN "
 "(1120000)  PCTFREE 20 PCTUSED 70 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 19"
 "92294400 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "CAT"
 "ALOG_COMP_PARTAPPL_DATA_03" LOGGING NOCOMPRESS, PARTITION "CPAD04" VALUES L"
 "ESS THAN (1150000)  PCTFREE 20 PCTUSED 70 INITRANS 1 MAXTRANS 255 STORAGE(I"
 "NITIAL 1741684736 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLES"
 "PACE "CATALOG_COMP_PARTAPPL_DATA_04" LOGGING NOCOMPRESS, PARTITION "CPAD05""
 " VALUES LESS THAN (1200000)  PCTFREE 20 PCTUSED 70 INITRANS 1 MAXTRANS 255 "
 "STORAGE(INITIAL 2239758336 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAUL"
 "T) TABLESPACE "CATALOG_COMP_PARTAPPL_DATA_05" LOGGING NOCOMPRESS, PARTITION"
 " "CPAD06" VALUES LESS THAN (1240000)  PCTFREE 20 PCTUSED 70 INITRANS 1 MAXT"
 "RANS 255 STORAGE(INITIAL 1790967808 FREELISTS 1 FREELIST GROUPS 1 BUFFER_PO"
 "OL DEFAULT) TABLESPACE "CATALOG_COMP_PARTAPPL_DATA_06" LOGGING NOCOMPRESS, "
 "PARTITION "CPAD07" VALUES LESS THAN (1280000)  PCTFREE 20 PCTUSED 70 INITRA"
 "NS 1 MAXTRANS 255 STORAGE(INITIAL 1647312896 FREELISTS 1 FREELIST GROUPS 1 "
 "BUFFER_POOL DEFAULT) TABLESPACE "CATALOG_COMP_PARTAPPL_DATA_07" LOGGING NOC"
 "OMPRESS, PARTITION "CPAD08" VALUES LESS THAN (MAXVALUE)  PCTFREE 20 PCTUSED"
 " 70 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 2161115136 FREELISTS 1 FREELIST"
 " GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "_DATA_08" L"
 "OGGING NOCOMPRESS )"
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'DATA_01'


This is partition table.I am trying to load the dump (of partition table) from local machine
to my local database.

The dump was created from Sun solaris server (source db).
The table belongs to Jack schema.

I am importing the dump file to MAHESH schema in local database.

Please advice how to fix this error .

Regards,

Re: ORA-01950: no privileges on tablespace [message #546878 is a reply to message #546877] Fri, 09 March 2012 10:17 Go to previous messageGo to next message
Michel Cadot
Messages: 67289
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01950: no privileges on tablespace '%s'
 *Cause:  User does not have privileges to allocate an extent in the
          specified tablespace.
 *Action: Grant the user the appropriate system privileges or grant the user
          space resource on the tablespace.


Your user has no quota on this tablespace.
See ALTER USER to fix.

Regards
Michel

Re: ORA-01950: no privileges on tablespace [message #546933 is a reply to message #546878] Sat, 10 March 2012 07:15 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you Michel.

This issue is resolved.. Smile
Re: ORA-01950: no privileges on tablespace [message #552603 is a reply to message #546933] Thu, 26 April 2012 18:04 Go to previous messageGo to next message
perry0511
Messages: 5
Registered: April 2012
Junior Member
Grant the user the appropriate system privileges or grant the user space resource on the tablespace.

ALTER USER <user> QUOTA UNLIMITED ON <tablespace_name>
Re: ORA-01950: no privileges on tablespace [message #552638 is a reply to message #552603] Fri, 27 April 2012 02:49 Go to previous message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
@perry0511 - We appreciate that you trying to help but this thread is over a month old and the issue is already solved.
It would be more helpful to answer current threads.

In addition can you please read and follow How to use [code] tags and make your code easier to read?
Previous Topic: impde include
Next Topic: monitoring export ,import job and tuning
Goto Forum:
  


Current Time: Fri Aug 07 07:22:41 CDT 2020