報錯信息:
Export file created by EXPORT:V09.02.00 via direct path
Warning: the objects were exported by ICD, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "ADMIN" ("ADMIN" VARCHAR2(300) NOT NULL ENABLE, "PASSWORD" VAR"
"CHAR2(300) NOT NULL ENABLE, "FLAG" NUMBER(5, 0)) PCTFREE 10 PCTUSED 40 INI"
"TRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'ICD_SERVICE'
Import terminated successfully with warnings.
需要resource權限,賦給用戶resource后,問題解決.
目標數據庫的用戶是新建的,沒有賦resource權限