x86的数据库如何迁移到x64数据库

云裴

我现在的数据库是32位的centos+32位oracle 10.2.0.1。我在另一台服务器装了64位的centos和64位的oracle10.2.0.5。想把数据迁移到64位的服务器。
在32服务器exp导出后，在64位服务器上面imp导入时报错；

1. $ imp system/manager file=db110928.dmp fromuser=cw touser=cw
   
2. Import: Release 10.2.0.5.0 - Production on 星期三 9月 28 07:56:40 2011
   
3. Copyright (c) 1982, 2007, Oracle.  All rights reserved.
   
4. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
   
5. With the Partitioning, OLAP, Data Mining and Real Application Testing options
   
6. Export file created by EXPORT:V10.02.01 via conventional path
   
7. import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
   
8. . importing CW's objects into CW
   
9. IMP-00008: unrecognized statement in the export file:
   
10.    ) LOCATION ( 'sale1v3.dat' ) ) REJECT LIMIT 100
    
11. . . importing table                         "B1SJ"          0 rows imported
    
12. . . importing table                         "B2SJ"          0 rows imported
    
13. . . importing table                         "B3SJ"          0 rows imported
    
14. 。。。。。。。。。。。。（此处省略importing table）。。。。。。。。。。。
    
15. . . importing table                    "ZZ_ZW_MXZ"      30650 rows imported
    
16. IMP-00032: SQL statement exceeded buffer length
    
17. IMP-00008: unrecognized statement in the export file:
    
18.   '考勤状态：0表示可以参加考勤；1表示不可参加考勤。'
    
19. IMP-00015: following statement failed because the object already exists:
    
20. "CREATE FORCE VIEW "CW"."XT_DWB"                              ("DWDM","DWMC""
    
21. ") AS "
    
22. "select bmdm as dwdm,bmmc as dwmc from pbmdm"
    
23. ""
    
24. IMP-00015: following statement failed because the object already exists:
    
25. "CREATE FORCE VIEW "CW"."REPTDEPT"                              ("CODE","NAM"
    
26. "E") AS "
    
27. "select ltrim(rtrim(bmdm)) as code, ltrim(rtrim(bmmc)) as name from pbmdm wh"
    
28. "ere isok = 'Y'"
    
29. IMP-00015: following statement failed because the object already exists:
    
30. "CREATE FORCE VIEW "CW"."REPTUSER"                              ("CODE","PAS"
    
31. "S","NAME") AS "
    
32. "select code, role as pass, code as name from reptRole"
    
33. IMP-00032: SQL statement exceeded buffer length
    
34. IMP-00008: unrecognized statement in the export file:
    
35.   'Oracle_Database returns one entry for each database that is managed by Oracle
    
36. Enterprise Manager. View entries are created using the databases that are known
    
37. to the Enterprise Manager Management Repository. Note: A Real Application
    
38. Cluster is presented...
    
39. IMP-00032: SQL statement exceeded buffer length
    
40. IMP-00008: unrecognized statement in the export file:
    
41.   'Oracle_DatabaseInstance contains one entry for each Oracle Instance that is
    
42. centrally managed.  A Real Application Cluster has one entry for each of the
    
43. instances that manipulate it.  Instances of Oracle_DatabaseInstance are created
    
44. using the database ...
    
45. IMP-00032: SQL statement exceeded buffer length
    
46. IMP-00008: unrecognized statement in the export file:
    
47.   'An Oracle_DatabaseSystem represents the existence of an Oracle database
    
48. environment as a manageable entity.  Instances of Oracle_DatabaseSystem are
    
49. used to navigate to the software characteristics of the database environment
    
50. that are modeled within the...
    
51. IMP-00032: SQL statement exceeded buffer length
    
52. IMP-00008: unrecognized statement in the export file:
    
53.   'The AssociatedDBSystem association identifies the database system that was used
    
54. to create the database.This association links an Oracle Database with
    
55. thedatabase system elements that are related.'
    
56. IMP-00032: SQL statement exceeded buffer length
    
57. IMP-00008: unrecognized statement in the export file:
    
58.   'The InstanceAvailableToDB association relates an Oracle database and its
    
59. instances.'
    
60. IMP-00032: SQL statement exceeded buffer length
    
61. IMP-00008: unrecognized statement in the export file:
    
62.   'Oracle_DBInstanceStatistics contains statistics for a database instance.  These
    
63. are retrieved from the Oracle Managment Repository that is managing the
    
64. database upon request from a managment client.'
    
65. IMP-00032: SQL statement exceeded buffer length
    
66. IMP-00008: unrecognized statement in the export file:
    
67.   'Oracle_DatabaseStatistics provides current information about the statistics for
    
68. a database.  Database statistics pertain to the database and have the same
    
69. value regardless of the database instance that is used.'
    
70. IMP-00032: SQL statement exceeded buffer length
    
71. IMP-00008: unrecognized statement in the export file:
    
72.   'Oracle_CurrentDBInstanceStats is an association that relates a Oracle database
    
73. instance to its current statistical information.'
    
74. IMP-00032: SQL statement exceeded buffer length
    
75. IMP-00008: unrecognized statement in the export file:
    
76.   'Oracle_CurrentDBStatistics is an association that relates a Oracle database to
    
77. its current statistical information.'
    
78. Import terminated successfully with warnings.
    

复制代码

而如果在64位服务器直接exp的话也会报错。应该怎么迁移这个数据呢

1. $ exp system/manager@db1 file=db123.dmp full=y
   
2. 
   
3. Export: Release 10.2.0.5.0 - Production on 星期三 9月 28 08:01:03 2011
   
4. 
   
5. Copyright (c) 1982, 2007, Oracle.  All rights reserved.
   
6. 
   
7. 
   
8. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
   
9. With the Partitioning, OLAP and Data Mining options
   
10. Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
    
11. 
    
12. About to export the entire database ...
    
13. . exporting tablespace definitions
    
14. . exporting profiles
    
15. . exporting user definitions
    
16. . exporting roles
    
17. . exporting resource costs
    
18. . exporting rollback segment definitions
    
19. . exporting database links
    
20. . exporting sequence numbers
    
21. . exporting directory aliases
    
22. . exporting context namespaces
    
23. . exporting foreign function library names
    
24. . exporting PUBLIC type synonyms
    
25. EXP-00008: ORACLE error 904 encountered
    
26. ORA-00904: "POLTYP": invalid identifier
    
27. EXP-00000: Export terminated unsuccessfully
    

复制代码

云裴

我在自己电脑装了32位windows的10.2.0.5版本客户端，exp导出也同样报错。看来10.2.0.5版本的exp不能导出10.2.0.1版本的数据。明天我重新装一下64位linux系统和oracle后暂不升级，把数据导入后再升级为10.2.0.5看看会不会有什么问题。

guyeh

把你的32 bit oracle服务器作为客户端执行imp应该不会有问题的。

caribe

character/language setting...