oracle11g imp性能,怎么最快地把本机的oracle11g数据导入xe
可以,谢谢
E:\oracle\product\11.1.0\db_1\BIN>exp oo/oo tables=p1t file=e:\cache\p1t.dmp direct=y
Export: Release 11.1.0.7.0 - Production on 星期三 2月 11 15:20:50 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
即将导出指定的表通过直接路径...
. . 正在导出表 P1T
成功终止导出, 没有出现警告。
E:\cache>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 2月 11 15:23:31 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> create user oo identified by oo default tablespace yntbs;
User created.
SQL> grant connect,dba to oo;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
E:\cache>imp oo/oo file=p1t.dmp
Import: Release 10.2.0.1.0 - Production on 星期三 2月 11 15:24:51 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
E:\cache>E:\oracle\product\11.1.0\db_1\BIN\imp oo/oo file=p1t.dmp
Import: Release 11.1.0.7.0 - Production on 星期三 2月 11 15:25:27 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
IMP-00058: 遇到 ORACLE 错误 12560
ORA-12560: TNS: 协议适配器错误
IMP-00000: 未成功终止导入
E:\oracle\product\11.1.0\db_1\BIN>cd \cache
E:\cache>exp oo/oo@10.4.105.213/o11g tables=p1t file=e:\cache\p1.dmp direct=y
Export: Release 10.2.0.1.0 - Production on 星期四 2月 12 07:49:15 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Direct Path ...
. . exporting table P1T
Export terminated successfully without warnings.
E:\cache>imp oo/oo file=p1.dmp tables=p1t ignore=y
Import: Release 10.2.0.1.0 - Production on 星期四 2月 12 07:52:38 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productio
Export file created by EXPORT:V10.02.01 via direct path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing OO's objects into OO
. importing OO's objects into OO
IMP-00017: following statement failed with ORACLE error 439:
"CREATE TABLE "P1T" ("SURVEYOBJECTID" NUMBER(30, 0), "DATAINDEX" VARCHAR2(8)"
", "C9" VARCHAR2(200), "C10" VARCHAR2(200), "C11" VARCHAR2(200), "C12" VARCH"
"AR2(200), "C13" VARCHAR2(200), "C14" CHAR(2), "C16" VARCHAR2(200), "C17" CH"
"AR(1), "C18" CHAR(1), "C19" VARCHAR2(200), "C15" NUMBER) PCTFREE 0 PCTUSED"
" 40 INITRANS 1 MAXTRANS 255 TABLESPACE "YNTBS" LOGGING COMPRESS PARTITION B"
"Y RANGE ("SURVEYOBJECTID" ) (PARTITION "P8611" VALUES LESS THAN ('86120000"
"00000000000000000') PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(I"
"NITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "
""YNTBS" LOGGING COMPRESS, PARTITION "P8612" VALUES LESS THAN ('861300000000"
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Partitioning
Import terminated successfully with warnings.
E:\cache>
E:\cache>
E:\cache>sqlplus oo/oo
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 2月 12 07:53:48 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> CREATE TABLE "P1T" ("SURVEYOBJECTID" NUMBER(30, 0), "DATAINDEX" VARCHAR2(8), "C9" VARCHAR2(200), "C10" VARCHAR2(200),
2 "C11" VARCHAR2(200), "C12" VARCHAR2(200), "C13" VARCHAR2(200), "C14" CHAR(2), "C16" VARCHAR2(200), "C17" CHAR(1),
3 "C18" CHAR(1), "C19" VARCHAR2(200), "C15" NUMBER) ;
Table created.
SQL> exit
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
E:\cache>imp oo/oo file=p1.dmp tables=p1t ignore=y
Import: Release 10.2.0.1.0 - Production on 星期四 2月 12 07:54:17 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Export file created by EXPORT:V10.02.01 via direct path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing OO's objects into OO
. importing OO's objects into OO
. . importing partition "P1T":"P8611" 0 rows imported
...
. . importing partition "P1T":"P8665" 0 rows imported
Import terminated successfully without warnings.
总结
以上是生活随笔为你收集整理的oracle11g imp性能,怎么最快地把本机的oracle11g数据导入xe的全部内容，希望文章能够帮你解决所遇到的问题。
- 上一篇： java 压缩jar 仓库,java服务
- 下一篇： android plugin 镜像,co