With navicat DMP file to import, is an old version of DMP, appear the following error now, baidu along while also didn't solve, for


(DPI) Job Start
(DPI) Getting progress for job SYS_IMPORT_FULL_01
(DPI) has succeeded in loading/unloading the main table "SYS". "SYS_IMPORT_FULL_01
"(DPI) to start the "SYS". "SYS_IMPORT_FULL_01" :
(DPI) processing object type TABLE_EXPORT/TABLE/TABLE
(ERR) ORA - 39083: object type TABLE: "the GIS". "CJZ_DWTZ_01" create failure, there is an error:
ORA - 01950: the table space 'GIS_DATA without permission

Failure of SQL is:
CREATE TABLE "GIS"."CJZ_DWTZ_01" ("PRIPID" VARCHAR2(36 BYTE), "DOMDISTRICT" VARCHAR2(500 BYTE), "REGCAP" NUMBER(26,6), "INDUSTRYCO" VARCHAR2(8 BYTE), "WORCAP" NUMBER, "ENTSTATUS" VARCHAR2(500 BYTE), "CONDATE" DATE, "GOOGLE_LAT" VARCHAR2(20 BYTE), "GOOGLE_LNG" VARCHAR2(100 BYTE), "CONDATE_CODE" NUMBER, "ID" VARCHAR2(20 BYTE)) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "GIS_DATA"

CodePudding user response:

Did you give the user a dba permissions

CodePudding user response:

With the dba role users perform:
The alter user GIS quota umlimited on GIS_DATA;

CodePudding user response:

refer to the second floor NextAction response:

with the dba role users perform:
The alter user GIS quota umlimited on GIS_DATA;

thanks, done

CodePudding user response:

Add a connect directly, the resource role is the most basic!