ORA-01950: no privileges on tablespace [message #546877] |
Fri, 09 March 2012 10:10 |
|
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,
|
|
|
|
|
|
|