ORA-01658 unable to create INITIAL extent for segment in ablespace string Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created. Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL.
在DBA下还是在哪呢
用DBA我连不上远程数据库
我记得上次安装的可以
不知道是怎么回事我用PLSQLDev 将数据库表和对象导出
但是导入时出错
错误如下:
D:\oracle\ora81\bin\IMP.EXE log=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\plsimp.log file=C:\yzwl\database\yzwl.dmp userid=yzwl/yzwluser1@hyy buffer=4096 commit=no full=yes grants=yes ignore=yes indexes=yes rows=yes show=no constraints=yes连接到: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production经由常规路径导出由EXPORT:V08.01.07创建的文件
已经完成ZHS16GBK字符集和ZHS16GBK NCHAR 字符集中的导入
. 正在将YZWL的对象导入到 YZWL
IMP-00017: 由于 ORACLE 错误1658,以下的语句失败
"CREATE TABLE "BMCS_TABLE" ("BMDM" NUMBER(4, 0) NOT NULL ENABLE, "XSBMDM" NU"
"MBER(4, 0) NOT NULL ENABLE, "GH" VARCHAR2(8) NOT NULL ENABLE, "XGSJ" DATE N"
"OT NULL ENABLE) PCTFREE 10 PCTUSED 60 INITRANS 2 MAXTRANS 255 LOGGING STOR"
"AGE(INITIAL 2129920 NEXT 2097152 MINEXTENTS 1 MAXEXTENTS 10 PCTINCREASE 0 F"
"REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
IMP-00003: ORACLE 错误1658出现
ORA-01658: 无法为表空间HYY中的段创建 INITIAL 区
. . 正在导入表 "BMDM_TABLE"
IMP-00058: ORACLE 错误4098出现
ORA-04098: 触发器 'YZWL.TIA_BMDM_TABLE' 无效且未通过重新确认
IMP-00017: 由于 ORACLE 错误1917,以下的语句失败
"GRANT SELECT ON "BMDM_TABLE" TO "WLAPP""
IMP-00003: ORACLE 错误1917出现
ORA-01917: 用户或作用'WLAPP'不存在
IMP-00017: 由于 ORACLE 错误1917,以下的语句失败
"GRANT INSERT ON "BMDM_TABLE" TO "WLAPP""
IMP-00003: ORACLE 错误1917出现
ORA-01917: 用户或作用'WLAPP'不存在
IMP-00017: 由于 ORACLE 错误1917,以下的语句失败
"GRANT UPDATE ON "BMDM_TABLE" TO "WLAPP""
IMP-00003: ORACLE 错误1917出现
ORA-01917: 用户或作用'WLAPP'不存在
IMP-00017: 由于 ORACLE 错误1917,以下的语句失败
"GRANT DELETE ON "BMDM_TABLE" TO "WLAPP""
IMP-00003: ORACLE 错误1917出现
ORA-01917: 用户或作用'WLAPP'不存在
. . 正在导入表 "CATALOG_TABLE"
IMP-00019: 行被拒绝是因为 ORACLE 错误1
IMP-00003: ORACLE 错误1出现
ORA-00001: 违反唯一约束条件 (YZWL.PK_CATALOG_TABLE)
列 1 0
列 2 0
列 3 连锁经营
列 4
列 5
列 6
列 7
列 8
列 9
列 10
IMP-00019: 行被拒绝是因为 ORACLE 错误1
IMP-00003: ORACLE 错误1出现
ORA-00001: 违反唯一约束条件 (YZWL.PK_CATALOG_TABLE)
列 1 5
列 2 0
列 3 摩托罗拉手机
列 4 264
列 5
列 6
列 7
列 8
列 9 06-1月 -2003:11:30:20
列 10 26401
IMP-00019: 行被拒绝是因为 ORACLE 错误1
IMP-00003: ORACLE 错误1出现
ORA-01917: 用户或作用'WLAPP'不存在
IMP-00017: 由于 ORACLE 错误1917,以下的语句失败
"GRANT INSERT ON "HYPAYFEE_TABLE" TO "WLAPP""
IMP-00003: ORACLE 错误1917出现
ORA-01917: 用户或作用'WLAPP'不存在
IMP-00017: 由于 ORACLE 错误1917,以下的语句失败
"GRANT UPDATE ON "HYPAYFEE_TABLE" TO "WLAPP""
IMP-00003: ORACLE 错误1917出现
ORA-01917: 用户或作用'WLAPP'不存在
IMP-00017: 由于 ORACLE 错误1917,以下的语句失败
"GRANT DELETE ON "HYPAYFEE_TABLE" TO "WLAPP""
IMP-00003: ORACLE 错误1917出现
ORA-01917: 用户或作用'WLAPP'不存在
IMP-00017: 由于 ORACLE 错误1658,以下的语句失败
"CREATE TABLE "HY_TABLE" ("ID" NUMBER(8, 0) NOT NULL ENABLE, "LINKPOS" NUMBE"
"R(8, 0), "BARCODE" VARCHAR2(16), "NAME" VARCHAR2(8), "SEX" NUMBER(8, 0), "L"
"IVE" VARCHAR2(64), "TEL" VARCHAR2(16), "PAGING" VARCHAR2(16), "ZJ" VARCHAR2"
"(20), "BRITHDAY" DATE, "POSTCODE" NUMBER(8, 0), "WORKDEP" VARCHAR2(64), "JF"
"" NUMBER(10, 2), "ZK" NUMBER(8, 0), "INTRO" VARCHAR2(8), "XYD" NUMBER(8, 0)"
", "YXQ" NUMBER(8, 0), "THSJ" DATE, "KHSJ" DATE, "OPERCODE" VARCHAR2(8), "DO"
"DATE" DATE, "EMAIL" VARCHAR2(32)) PCTFREE 10 PCTUSED 60 INITRANS 2 MAXTRAN"
"S 255 LOGGING STORAGE(INITIAL 5242880 NEXT 5242880 MINEXTENTS 1 MAXEXTENTS "
"10 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" "
IMP-00003: ORACLE 错误1658出现
ORA-01658: 无法为表空间HYY中的段创建 INITIAL 区
IMP-00017: 由于 ORACLE 错误1658,以下的语句失败
"CREATE TABLE "KCB_SUBJOIN" ("SPDM" NUMBER(8, 0) NOT NULL ENABLE, "SUBID" VA"
"RCHAR2(32) NOT NULL ENABLE, "ZJSL" NUMBER(8, 2), "SJSL" NUMBER(8, 2), "CPZJ"
"SL" NUMBER(8, 2), "CPSJSL" NUMBER(8, 2), "CKDM" NUMBER(4, 0), "CWDM" VARCHA"
"R2(16) NOT NULL ENABLE, "SCRQ" DATE NOT NULL ENABLE, "JG" NUMBER(8, 2)) PC"
"TFREE 10 PCTUSED 60 INITRANS 2 MAXTRANS 255 LOGGING STORAGE(INITIAL 5242880"
" NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 10 PCTINCREASE 0 FREELISTS 1 FREELIST"
" GROUPS 1 BUFFER_POOL DEFAULT) "
IMP-00003: ORACLE 错误1658出现
ORA-01658: 无法为表空间HYY中的段创建 INITIAL 区
IMP-00017: 由于 ORACLE 错误1658,以下的语句失败
"CREATE TABLE "KCB_TABLE" ("SPDM" NUMBER(8, 0) NOT NULL ENABLE, "ZJSL" NUMBE"
"R(8, 2), "SJSL" NUMBER(8, 2), "CPZJSL" NUMBER(8, 2), "CPSJSL" NUMBER(8, 2),"
" "CKDM" NUMBER(4, 0), "CWDM" VARCHAR2(16) NOT NULL ENABLE, "SCRQ" DATE NOT "
"NULL ENABLE, "JG" NUMBER(8, 2), "SUB_FLAG" NUMBER(2, 0)) PCTFREE 10 PCTUSE"
"D 60 INITRANS 2 MAXTRANS 255 LOGGING STORAGE(INITIAL 10485760 NEXT 10485760"
" MINEXTENTS 1 MAXEXTENTS 10 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUF"
"FER_POOL DEFAULT) "
IMP-00003: ORACLE 错误1658出现
ORA-01658: 无法为表空间HYY中的段创建 INITIAL 区
IMP-00017: 由于 ORACLE 错误1658,以下的语句失败
"CREATE TABLE "KCLJG_TABLE" ("CKDM" NUMBER(4, 0) NOT NULL ENABLE, "SPDM" NUM"
"BER(8, 0) NOT NULL ENABLE, "ZDKCL" NUMBER(8, 2), "ZGKCL" NUMBER(8, 2)) PCT"
"FREE 10 PCTUSED 60 INITRANS 2 MAXTRANS 255 LOGGING STORAGE(INITIAL 8396800 "
"NEXT 4194304 MINEXTENTS 1 MAXEXTENTS 10 PCTINCREASE 0 FREELISTS 1 FREELIST "
"GROUPS 1 BUFFER_POOL DEFAULT) "
IMP-00003: ORACLE 错误1658出现
ORA-01658: 无法为表空间HYY中的段创建 INITIAL 区
IMP-00017: 由于 ORACLE 错误1658,以下的语句失败
"CREATE TABLE "KCTJ_TABLE" ("RQ" DATE NOT NULL ENABLE, "SPDM" NUMBER(8, 0) N"
"OT NULL ENABLE, "CKDM" NUMBER(4, 0) NOT NULL ENABLE, "RKSL" NUMBER(8, 2), ""
"XSSL" NUMBER(8, 2), "XSJE" NUMBER(8, 2), "PYSL" NUMBER(8, 2), "KCSL" NUMBER"
"(8, 2), "JG" NUMBER(8, 2), "REPRICE1" NUMBER(8, 2)) PCTFREE 10 PCTUSED 60 "
"INITRANS 2 MAXTRANS 255 LOGGING STORAGE(INITIAL 41943040 NEXT 10485760 MINE"
"XTENTS 1 MAXEXTENTS 10 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P"
"OOL DEFAULT) "
IMP-00003: ORACLE 错误1658出现
ORA-01658: 无法为表空间HYY中的段创建 INITIAL 区
IMP-00017: 由于 ORACLE 错误1658,以下的语句失败
Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.
Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL.