E:\>imp licheng/licheng tables=wf:p1_10Import: Release 9.0.1.1.1 - Production on 星期五 12月 19 21:06:36 2008(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.00.01创建的文件
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
. 正在将LICHENG的对象导入到 LICHENG
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TABLE "WF" ("X" NUMBER(*,0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTR"
"ANS 255 TABLESPACE "LICHENG" LOGGING PARTITION BY RANGE ("X" ) (PARTITION "
""P1_10" VALUES LESS THAN (10) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
"5 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "LICHENG""
" LOGGING, PARTITION "P2_20" VALUES LESS THAN (maxvalue) PCTFREE 10 PCTUSED"
" 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROU"
"PS 1) TABLESPACE "LICHENG" LOGGING )"
IMP-00057: 警告: 转储文件可能不含有此表的所有分区数据
IMP-00055: 警告: 导出文件中未找到分区或子分区 "WF": "P1_10"
成功终止导入,但出现警告。E:\>
连接到: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production经由常规路径导出由EXPORT:V09.00.01创建的文件
已经完成ZHS16GBK字符集和AL16UTF16 NCHAR 字符集中的导入
. 正在将LICHENG的对象导入到 LICHENG
IMP-00015: 由于对象已存在,下列语句失败:
"CREATE TABLE "WF" ("X" NUMBER(*,0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTR"
"ANS 255 TABLESPACE "LICHENG" LOGGING PARTITION BY RANGE ("X" ) (PARTITION "
""P1_10" VALUES LESS THAN (10) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
"5 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "LICHENG""
" LOGGING, PARTITION "P2_20" VALUES LESS THAN (maxvalue) PCTFREE 10 PCTUSED"
" 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROU"
"PS 1) TABLESPACE "LICHENG" LOGGING )"
IMP-00057: 警告: 转储文件可能不含有此表的所有分区数据
IMP-00055: 警告: 导出文件中未找到分区或子分区 "WF": "P1_10"
成功终止导入,但出现警告。E:\>
连接到: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集即将导出指定的表通过常规路径 ...
. . 正在导出表 WF
. . 正在导出分区 P1_10 9 行被导出
在没有警告的情况下成功终止导出。
哈哈