很明显的错误,
IMP-00003: 遇到 ORACLE 错误 1435
ORA-01435: user does not exist因为你的redhat下oracle没有这些用户所以授权的时候发生错误,先把表空间用户建立起来,然后在IMP
IMP-00003: 遇到 ORACLE 错误 1435
ORA-01435: user does not exist因为你的redhat下oracle没有这些用户所以授权的时候发生错误,先把表空间用户建立起来,然后在IMP
. 正在将SMSUSER的对象导入到 SYSTEM
. 正在将SMSUSER的对象导入到 SMSUSER
. 正在将SPPUSER的对象导入到 SPPUSER
. 正在将SMPUSER的对象导入到 SMPUSER
. 正在将SPPUSER的对象导入到 SPPUSER
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TYPE "MT" TIMESTAMP '2005-02-27:16:06:41' OID 'FE58D47F221F49F6B2E24"
"EF23C30723B' "
" AS OBJECT"
"/******************************************************"
" * 自定义类型名:MT"
" * 目的:用于封装MT下行信息"
" ******************************************************/"
"("
" DEST_MOBILENO VARCHAR2(32), -- 手机号"
" LONG_NUMBER VARCHAR2(21), -- 长号码"
" MT_CONTENT VARCHAR2(2000), -- MT下行消息内容"
" MT_ATTRIBUTE VARCHAR2(1000) -- MT属性 "
")"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TYPE "MTS" TIMESTAMP '2005-03-08:11:27:29' OID '52B195E177AC4C1BAB8F"
"3CBE4AEB84BF' "
" "
" "
" AS VARRAY(10) OF MT"
. 正在将SMPUSER的对象导入到 SMPUSER
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TYPE "MOMSG" TIMESTAMP '2005-02-27:16:02:01' OID '2435D9839E144098BE"
"EC5BB0A3F366AC' "
" AS OBJECT"
"/******************************************************"
" * 自定义类型名:MOMSG"
" * 目的:用于封装MO消息"
" ******************************************************/"
"("
" MOTYPE CHAR(1), -- MO类型[O订购 C取消 G普通]"
" MOBILENO VARCHAR2(32), -- 手机号"
" LONG_NUMBER VARCHAR2(21), -- 长号码"
" MO_CONTENT VARCHAR2(300) -- MT下行消息内容"
")"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TYPE "MT" TIMESTAMP '2005-02-27:16:02:01' OID '7E86788B3E4A43A4ACDC2"
"6F0D400154D' "
" AS OBJECT"
"/******************************************************"
" * 自定义类型名:MT"
" * 目的:用于封装MT下行信息"
" ******************************************************/"
"("
" DEST_MOBILENO VARCHAR2(32), -- 手机号"
" LONG_NUMBER VARCHAR2(21), -- 长号码"
" MT_CONTENT VARCHAR2(2000), -- MT下行消息内容"
" MT_ATTRIBUTE VARCHAR2(1000) -- MT属性 "
")"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TYPE "MTS" TIMESTAMP '2005-02-27:16:02:01' OID '9E78F663F00D41C393E0"
"AC791C8B3BCA' "
" "
" "
" AS VARRAY(10) OF MT"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TYPE "PMT" TIMESTAMP '2005-02-27:16:02:01' OID '2C241F6ED9FC4E94ACC0"
"B5697450A61F' "
" AS OBJECT"
"/******************************************************"
" * 自定义类型名:PMT"
" * 目的:用于封装带有资费的MT下行信息"
" ******************************************************/"
"("
" DEST_MOBILENO VARCHAR2(32), -- 目标手机号"
" FEE_MOBILENO VARCHAR2(32), -- 收费手机号"
" LONG_NUMBER VARCHAR2(21), -- 长号码"
" MT_CONTENT VARCHAR2(140), -- MT下行消息内容"
" SERVICE_ID VARCHAR2(10), -- 业务代码"
" CLIENT_ID NUMBER(4), -- 网关ID"
" CLIENT_NAME VARCHAR2(10), -- 网关名"
" MT_FLAG NUMBER(1), -- 下行标志,联通用"
" MSG_FMT NUMBER(1), -- 消息格式"
" FEE_TYPE NUMBER(1), -- 费用类型"
" FEE_VALUE NUMBER(4), -- 费用单价 "
" BEG_REPORT NUMBER(1), -- 状态报告"
" MT_TIME DATE, -- 本记录生成时间"
" LINK_ID VARCHAR2(400) -- LINKID"
")"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TYPE "PMTS" TIMESTAMP '2005-02-27:16:02:01' OID '783E2C2ED1C344B5B07"
"94838AA7269E1' "
" "
" "
" AS VARRAY(10) OF PMT"
. 正在将SMSUSER的对象导入到 SMSUSER
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE SEQUENCE "SEQ_MT_BUF" MINVALUE 199050218165050999 MAXVALUE 999999999"
"999999999999999999 INCREMENT BY 1000 START WITH 199050218165771999 CACHE 20"
" NOORDER NOCYCLE"
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE SEQUENCE "SEQ_TEST1" MINVALUE 1 MAXVALUE 999999999999999999999999999"
" INCREMENT BY 1 START WITH 35981 CACHE 20 NOORDER NOCYCLE"
IMP-00017: 由于 ORACLE 的 1950 错误,以下的语句失败
"CREATE TABLE "MO_BUF" ("U_ID" NUMBER NOT NULL ENABLE, "CLIENT_ID" NUMBER NO"
"T NULL ENABLE, "CLIENT_NAME" VARCHAR2(10), "SP_NUMBER" VARCHAR2(21) NOT NUL"
"L ENABLE, "MS_NO" VARCHAR2(21) NOT NULL ENABLE, "MO_TIME" DATE NOT NULL ENA"
"BLE, "SERVICE_ID" VARCHAR2(10), "MSG_CONTENT" VARCHAR2(150), "LINK_ID" VARC"
"HAR2(45)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65"
"536 FREELISTS 1 FREELIST GROUPS 1) LOGGING"
IMP-00003: 遇到 ORACLE 错误 1950
ORA-01950: no privileges on tablespace 'SMSUSER'
IMP-00017: 由于 ORACLE 的 1950 错误,以下的语句失败
"CREATE TABLE "MO_LOG" ("U_ID" NUMBER NOT NULL ENABLE, "CLIENT_ID" NUMBER(3,"
" 0) NOT NULL ENABLE, "CLIENT_NAME" VARCHAR2(10), "SP_NUMBER" VARCHAR2(21) N"
"OT NULL ENABLE, "MS_NO" VARCHAR2(21) NOT NULL ENABLE, "MO_TIME" DATE NOT NU"
"LL ENABLE, "SERVICE_ID" VARCHAR2(10), "MSG_CONTENT" VARCHAR2(150), "LINK_ID"
"" VARCHAR2(40), "MSG_ID" VARCHAR2(30)) PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
"XTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
" LOGGING"