C:\Documents and Settings\Administrator>imp system/manager@jsj file=c:\xj_xjb.dm
p FULL=yImport: Release 9.0.1.1.1 - Production on 星期二 8月 10 15:05:47 2010(c) Copyright 2001 Oracle Corporation. All rights reserved.
连接到: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production经由常规路径导出由EXPORT:V09.02.00创建的文件警告: 此对象由 JW 导出, 而不是当前用户已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
. 正在将JW的对象导入到 SYSTEM
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "XJ_XJB" ("XH" VARCHAR2(12) NOT NULL ENABLE, "XM" VARCHAR2(40)"
" NOT NULL ENABLE, "YWXM" VARCHAR2(40), "SFZH" VARCHAR2(18), "XB" VARCHAR2(2"
"), "MZ" VARCHAR2(20), "JG" VARCHAR2(100), "CSRQ" VARCHAR2(8), "ZZMM" VARCHA"
"R2(20), "XSH" VARCHAR2(5), "ZYH" VARCHAR2(8), "ZYFX" VARCHAR2(30), "BH" VAR"
"CHAR2(10), "RXNJ" VARCHAR2(4), "SSNJ" VARCHAR2(4), "XSLB" VARCHAR2(10), "SF"
"YXJ" VARCHAR2(2), "KQ" VARCHAR2(30), "BYZX" VARCHAR2(30), "GKZF" NUMBER(5, "
"1), "WYYZ" VARCHAR2(2), "SSDZ" VARCHAR2(20), "BYLB" VARCHAR2(10), "FLFX" VA"
"RCHAR2(14), "BYRQ" VARCHAR2(8), "BYZSBH" VARCHAR2(20), "BZ" VARCHAR2(60), ""
"LQH" VARCHAR2(10), "KSH" VARCHAR2(20), "RXRQ" VARCHAR2(8), "PYFS" VARCHAR2("
"20), "YMPY" VARCHAR2(10), "YDF" VARCHAR2(2), "XZ" VARCHAR2(20), "XMPY" VARC"
"HAR2(60), "CYM" VARCHAR2(40), "PYCC" VARCHAR2(10), "LXF" VARCHAR2(2), "XJZT"
"" VARCHAR2(8)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITI"
"AL 8151040 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "XDB" LOGGING NOCOMPRE"
"SS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
成功终止导入,但出现警告。
这是个什么错误 怎么解决啊 着急啊 大家帮帮忙啊………………
p FULL=yImport: Release 9.0.1.1.1 - Production on 星期二 8月 10 15:05:47 2010(c) Copyright 2001 Oracle Corporation. All rights reserved.
连接到: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production经由常规路径导出由EXPORT:V09.02.00创建的文件警告: 此对象由 JW 导出, 而不是当前用户已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
. 正在将JW的对象导入到 SYSTEM
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "XJ_XJB" ("XH" VARCHAR2(12) NOT NULL ENABLE, "XM" VARCHAR2(40)"
" NOT NULL ENABLE, "YWXM" VARCHAR2(40), "SFZH" VARCHAR2(18), "XB" VARCHAR2(2"
"), "MZ" VARCHAR2(20), "JG" VARCHAR2(100), "CSRQ" VARCHAR2(8), "ZZMM" VARCHA"
"R2(20), "XSH" VARCHAR2(5), "ZYH" VARCHAR2(8), "ZYFX" VARCHAR2(30), "BH" VAR"
"CHAR2(10), "RXNJ" VARCHAR2(4), "SSNJ" VARCHAR2(4), "XSLB" VARCHAR2(10), "SF"
"YXJ" VARCHAR2(2), "KQ" VARCHAR2(30), "BYZX" VARCHAR2(30), "GKZF" NUMBER(5, "
"1), "WYYZ" VARCHAR2(2), "SSDZ" VARCHAR2(20), "BYLB" VARCHAR2(10), "FLFX" VA"
"RCHAR2(14), "BYRQ" VARCHAR2(8), "BYZSBH" VARCHAR2(20), "BZ" VARCHAR2(60), ""
"LQH" VARCHAR2(10), "KSH" VARCHAR2(20), "RXRQ" VARCHAR2(8), "PYFS" VARCHAR2("
"20), "YMPY" VARCHAR2(10), "YDF" VARCHAR2(2), "XZ" VARCHAR2(20), "XMPY" VARC"
"HAR2(60), "CYM" VARCHAR2(40), "PYCC" VARCHAR2(10), "LXF" VARCHAR2(2), "XJZT"
"" VARCHAR2(8)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITI"
"AL 8151040 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "XDB" LOGGING NOCOMPRE"
"SS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
成功终止导入,但出现警告。
这是个什么错误 怎么解决啊 着急啊 大家帮帮忙啊………………
解决方案 »
- 如何获的表中各列
- 求高手解答
- create or replace trigger aufer_jyc_person_update after update on jyc_person触发器问题,无效
- 求救,有关oracle连接sql server
- 关于触发器的问题,敬请指点!!
- 怎样插入大于4000的字符串?第---3-----次发
- LINUX AS 3的下载地址,麻烦大家!
- 登录SQL*PLUS????
- 紧急高分:ora-01033:oracle initialization or shutdown in progress
- 如何安装Oracle附加包?
- Oracle 存储过程速度慢
- 请教一个大批量数据处理问题
"XM" VARCHAR2(40)"
" NOT NULL ENABLE,