我现在要把同一个数据库备份文件.dmp导给一台服务器上面的两个不同的数据库用户usera、userb,但是遇到个问题,这个备份文件里面建了CREATE TYPE,把备份文件导给第一个用户usera的时候不会报错,再把相同的备份文件导给第二个用户userb的时候就报错,报错内容如下:
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
"CREATE TYPE "SELL_DAN_ID" TIMESTAMP '2011-08-21:15:44:16' OID 'C35B541DE862"
"47C8881D62585A0046D4' "
" as object"
"("
" danid number(7)"
")"
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
"CREATE TYPE "SELL_DAN_ID_JIHE" TIMESTAMP '2011-08-21:15:44:18' OID '31E011F"
"B2EE04395A8AB14734E2897F8' "
" as table of sell_dan_id"
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
"CREATE TYPE "XSKF_CHOICE" TIMESTAMP '2011-09-07:11:09:44' OID '257E8091EC41"
"4C1A91792F3EA9A88AC7' as object ("
" xhidden nvarchar2(10),"
" xvalue nvarchar2(100)"
")"
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
"CREATE TYPE "XSKF_CHOICE_LST" TIMESTAMP '2011-09-07:11:09:48' OID 'E42C8D72"
"A57449F3A826A3A371D8A4E9' as table of xskf_choice"
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
请问各位高手要怎么样解决这个问题呢?
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
"CREATE TYPE "SELL_DAN_ID" TIMESTAMP '2011-08-21:15:44:16' OID 'C35B541DE862"
"47C8881D62585A0046D4' "
" as object"
"("
" danid number(7)"
")"
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
"CREATE TYPE "SELL_DAN_ID_JIHE" TIMESTAMP '2011-08-21:15:44:18' OID '31E011F"
"B2EE04395A8AB14734E2897F8' "
" as table of sell_dan_id"
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
"CREATE TYPE "XSKF_CHOICE" TIMESTAMP '2011-09-07:11:09:44' OID '257E8091EC41"
"4C1A91792F3EA9A88AC7' as object ("
" xhidden nvarchar2(10),"
" xvalue nvarchar2(100)"
")"
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
IMP-00017: 由于 ORACLE 错误 2304, 以下语句失败:
"CREATE TYPE "XSKF_CHOICE_LST" TIMESTAMP '2011-09-07:11:09:48' OID 'E42C8D72"
"A57449F3A826A3A371D8A4E9' as table of xskf_choice"
IMP-00003: 遇到 ORACLE 错误 2304
ORA-02304: 无效的对象标识符文字
请问各位高手要怎么样解决这个问题呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货