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.