2003 server中导出来DMP文件,为什么在XP里导不进去?是不是有什么要设置的,确定二个操作系统的oracle版本是相同的
解决方案 »
- 关于下面时间的解释
- 控制文件的移动
- oracle时间格式 在线等
- 求推荐一本ORACLE入门与提高的书(有MSSQL基础)
- 请教Oracle中字符排序问题。谢谢
- oracle数据库创建日志以及根据日志恢复数据,在线等
- 关于插入数据!
- 请问如何搜索局域网内oracle服务器
- 请问create table 返回值为2 是什么意思?
- oracle 9i里有没有像SQL SERVER 2000 中的是事件探查器的功能?
- oracle如何导出table的c语言结构?
- PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the
导入出错一大堆,最后结果是什么也没导入
下面列举一下错误:
IMP-00017: 由于 ORACLE 的 922 错误,以下的语句失败
"CREATE TABLE "WMS_RECEIVE_ITEM_ITEM" ("ID" NUMBER(*,0) NOT NULL ENABLE, "SH"
"EET_ID" NUMBER(*,0), "RECEIVE_ID" NUMBER(*,0), "PROD_ID" NUMBER(*,0), "ADVI"
"CE_SHELF" NUMBER(*,0), "FACT_SHELF" NUMBER(*,0), "FACT_NUM" NUMBER(10, 4), "
""BATCH_BARCODE" VARCHAR2(50), "BATCH_NO" VARCHAR2(50), "PRODUCE_BATCH" VARC"
"HAR2(50), "ASEPSIS_NO" VARCHAR2(50), "PRODUCE_DATE" DATE, "VALID_DATE" DATE"
", "STATE" NUMBER(*,0), "REMARKS" VARCHAR2(200), "MAKE_USER" NUMBER(*,0), "M"
"AKE_DATE" DATE, "DEAL_USER" NUMBER(*,0), "DEAL_DATE" DATE, "CHECK_USER" NUM"
"BER(*,0), "CHECK_DATE" DATE, "CHECK_STATE" NUMBER(*,0), "FINISH_USER" NUMBE"
"R(*,0), "FINISH_DATE" DATE, "TRAY_SERIAL_NO" VARCHAR2(50)) PCTFREE 10 PCTU"
"SED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST G"
"ROUPS 1) TABLESPACE "WMS09TEST" LOGGING NOCOMPRESS"
IMP-00003: 遇到 ORACLE 错误 922
ORA-00922: 缺少或无效选项
CREATE TABLE "WMS_RECEIVE_ITEM_ITEM" (
"ID" NUMBER(*,0) NOT NULL ENABLE,
"SHEET_ID" NUMBER(*,0),
"RECEIVE_ID" NUMBER(*,0),
"PROD_ID" NUMBER(*,0),
"ADVICE_SHELF" NUMBER(*,0),
"FACT_SHELF" NUMBER(*,0),
"FACT_NUM" NUMBER(10, 4),
"BATCH_BARCODE" VARCHAR2(50),
"BATCH_NO" VARCHAR2(50),
"PRODUCE_BATCH" VARCHAR2(50),
"ASEPSIS_NO" VARCHAR2(50),
"PRODUCE_DATE" DATE,
"VALID_DATE" DATE,
"STATE" NUMBER(*,0),
"REMARKS" VARCHAR2(200),
"MAKE_USER" NUMBER(*,0),
"MAKE_DATE" DATE,
"DEAL_USER" NUMBER(*,0),
"DEAL_DATE" DATE,
"CHECK_USER" NUMBER(*,0),
"CHECK_DATE" DATE,
"CHECK_STATE" NUMBER(*,0),
"FINISH_USER" NUMBER(*,0),
"FINISH_DATE" DATE,
"TRAY_SERIAL_NO" VARCHAR2(50))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)
TABLESPACE "WMS09TEST" LOGGING NOCOMPRESS