1.首先我用exp cgwp/cgwp@orcl file=xxxx.dmp 将数据导出(cgwp用户使用的表空间是cgwp)。
2.然后我新建了个cgwp_test用户,新建的表空间为cgwp_test.
3.接着执行imp cgwp_test/cgwp@orcl fromuser=cgwp touser=cgwp_test file=xxxx.dmp.当导到一半的时候报错,错误信息如下:
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CGWP
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "WORDEDIT" ("ID" NUMBER(10, 0) NOT NULL ENABLE, "DURL" VARCHAR"
"2(150) NOT NULL ENABLE, "SURL" VARCHAR2(150) NOT NULL ENABLE, "USER_ID" VAR"
"CHAR2(32) NOT NULL ENABLE, "WE_TIME" NUMBER(11, 0) NOT NULL ENABLE, "STAT" "
"NUMBER(11, 0) NOT NULL ENABLE, "WE_LOG" CLOB NOT NULL ENABLE, "XIUDING" NUM"
"BER(11, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 "
"STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TA"
"BLESPACE "CGWP" LOGGING NOCOMPRESS LOB ("WE_LOG") STORE AS (TABLESPACE "CG"
"WP" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL"
" 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CGWP
IMP-00017: following statement failed with ORACLE error 1658:
发现导入的表空间依然是cgwp而不是cgwp_test!!!!!!!
请各位走过路过的大侠们指点一下。
2.然后我新建了个cgwp_test用户,新建的表空间为cgwp_test.
3.接着执行imp cgwp_test/cgwp@orcl fromuser=cgwp touser=cgwp_test file=xxxx.dmp.当导到一半的时候报错,错误信息如下:
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CGWP
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "WORDEDIT" ("ID" NUMBER(10, 0) NOT NULL ENABLE, "DURL" VARCHAR"
"2(150) NOT NULL ENABLE, "SURL" VARCHAR2(150) NOT NULL ENABLE, "USER_ID" VAR"
"CHAR2(32) NOT NULL ENABLE, "WE_TIME" NUMBER(11, 0) NOT NULL ENABLE, "STAT" "
"NUMBER(11, 0) NOT NULL ENABLE, "WE_LOG" CLOB NOT NULL ENABLE, "XIUDING" NUM"
"BER(11, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 "
"STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TA"
"BLESPACE "CGWP" LOGGING NOCOMPRESS LOB ("WE_LOG") STORE AS (TABLESPACE "CG"
"WP" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL"
" 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace CGWP
IMP-00017: following statement failed with ORACLE error 1658:
发现导入的表空间依然是cgwp而不是cgwp_test!!!!!!!
请各位走过路过的大侠们指点一下。
解决方案 »
- 求助!oracle数据库如何保存SQL语句!
- 数据库重装了,如何使用原来的数据库。
- 【pro*c/c++预编译通不过-寸步难行啊】谁能帮我预编译通过呀?
- ORA-00972 identitify is too long
- oracle数据访问问题
- 如何让 用 group by 分组查询出来的数据以特定的顺序显示出来,而不是自动排列!!
- 自动加一
- 机子装了oracle后内存不够用怎么办?
- 在oracle中如何判断是否是数字?
- 120MB的SQL Server数据库用Migration Workbench迁移到Oracle数据库要多长时间?
- 关于oracle数据库ora-01122的错误.(很着急50分)
- ◇◇◇◆◆◆求快速sqlserver导入到Oracle(数据是海量)方法?◆◆◆◇◇◇
你把表空间建成和原数据库表空间一样,看能否导入?
如果我不希望原来的ABC和新增的QQQ这两个table放在同一个tablespace上怎么办呢?
alter user cgwp_test quota unlimited on cgwp_test;
alter user cgwp_test quota 0 on cgwp;