- 论坛徽章:
- 0
|
用户hn的对象原来在USERS表空间,用exp system/system owner=hn导出后,删掉用户hn及所有对象,新建表空间hn,新建用户hn,并设定其在USERS表空间上无可用空间,在表空间hn上无限制。用imp system/system fromuser=hn touser=hn 导入,信息如下,有两个表出现错误:
==========================================
. . 正在导入表 "SLZ_YSZMCLB" 21行被导入
. . 正在导入表 "SMT_DANWEI" 0行被导入
IMP-00017: 由于 ORACLE 的 1950 错误,以下的语句失败
"CREATE TABLE "SMT_DWJYBC" ("BCBH" VARCHAR2(12) NOT NULL ENABLE, "BCMC" VARC"
"HAR2(80) NOT NULL ENABLE, "LDXM" VARCHAR2(1000), "LDYM" VARCHAR2(1000), "YW"
"MC" VARCHAR2(1000), "WXXFL" CHAR(1) NOT NULL ENABLE, "JZMC" VARCHAR2(1000),"
" "FBDQ" VARCHAR2(1000), "JCBW" VARCHAR2(1000), "JYCS" VARCHAR2(1000), "QIXX"
"" VARCHAR2(1000), "TPXX" BLOB, "Z_NOTE" VARCHAR2(200), "Z_AUTHER" VARCHAR2("
"30), "Z_STATUS" CHAR(1), "Z_TIME" VARCHAR2(30)) PCTFREE 10 PCTUSED 40 INIT"
"RANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TA"
"BLESPACE "USERS" LOGGING NOCOMPRESS LOB ("TPXX") STORE AS (TABLESPACE "USE"
"RS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL"
" 65536 FREELISTS 1 FREELIST GROUPS 1))"
IMP-00003: 遇到 ORACLE 错误 1950
ORA-01950: 表空间'USERS'中无权限
IMP-00017: 由于 ORACLE 的 1950 错误,以下的语句失败
"CREATE TABLE "SMT_GNJYDX" ("GNJYDX_ID" VARCHAR2(12) NOT NULL ENABLE, "BCMC""
" VARCHAR2(80) NOT NULL ENABLE, "BCZL" CHAR(1), "LDMC" VARCHAR2(1000), "YWMC"
"" VARCHAR2(1000), "FLDW" VARCHAR2(1000), "JZMC" VARCHAR2(1000), "FBDQ" VARC"
"HAR2(1000), "WHZZ" VARCHAR2(1000), "BCFL" CHAR(1) NOT NULL ENABLE, "CBTJ" V"
"ARCHAR2(1000), "JYFF" VARCHAR2(1000), "CHCL" VARCHAR2(1000), "FBGL" VARCHAR"
"2(1000), "BYJD" VARCHAR2(1000), "YSJYCP" VARCHAR2(1000), "DCFF" VARCHAR2(10"
"00), "SNJY" VARCHAR2(1000), "ZHONGLEI" CHAR(1) NOT NULL ENABLE, "QTXX" VARC"
"HAR2(1000), "TPXX" BLOB, "Z_NOTE" VARCHAR2(200), "Z_AUTHER" VARCHAR2(30), ""
"Z_STATUS" CHAR(1), "Z_TIME" VARCHAR2(30)) PCTFREE 10 PCTUSED 40 INITRANS 1"
" MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPA"
"CE "USERS" LOGGING NOCOMPRESS LOB ("TPXX") STORE AS (TABLESPACE "USERS" EN"
"ABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536"
" FREELISTS 1 FREELIST GROUPS 1))"
IMP-00003: 遇到 ORACLE 错误 1950
ORA-01950: 表空间'USERS'中无权限
. . 正在导入表 "SSB_DYBJ" 12行被导入
. . 正在导入表 "SSB_DYBJZW" 18行被导入
准备启用约束条件...
成功终止导入,但出现警告。
==========================================
在企业管理器中查看hn用户,发现已导入的表及索引都已位于hn表空间。请教, 如何将发生错误未能导入的两个表也导入hn表空间? |
|