Oracle 10g schema migration
With Version 10G, Oracle introduces the so called Data Pump for doing data exports an imports. given an oracle 9.0.2.4 DB (solaris) and an oracle 10g (Win2000) i wanted to copy a schema's metadata. Unfortunately this seems to be not possible with the "data pump".
First approach:
9.2 Schema export with "exp", then dumpfile import using Data Pump. Oracle documentation ("Oracle 10g Database Utilities" Manual) says Data Pump does not support old dumpfiles (exp generated).
Second approach:
Data Pump supports a direct export-import via network (Database link) without dumpfile generation.
>impdp mydata/no NETWORK_LINK=mydb3e.world SCHEMAS=KNO_DATA CONTENT=METADATA_ONLY
Import: Release 10.1.0.2.0 - Production on Montag, 23 August, 2004 13:56
Copyright (c) 2003, Oracle. All rights reserved.
Angemeldet bei: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining options
ORA-39006: Interner Fehler
ORA-39022: Datenbankversion 9.2.0.4.0 wird nicht unterst³tzt.
Third try:
Data Pump export (expdp) to a dump file, then impdp into 10G.
>EXPDP mydata/no NETWORK_LINK=mydb3e.world DUMPFILE=dpump_dir:no3enodata.dmp SCHEMAS=MYDATA CONTENT=METADATA_ONLY
Export: Release 10.1.0.2.0 - Production on Montag, 23 August, 2004 14:11
Copyright (c) 2003, Oracle. All rights reserved.
Angemeldet bei: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining options
ORA-39006: Interner Fehler
ORA-39065: Unerwartete Master-Prozess-Exception in DISPATCH
ORA-00904: "SYS"."KUPM$MCP"."GET_ENDIANNESS": ung³ltiger Bezeichner
ORA-39097: Bei Data Pump-Job ist ein unerwarteter Fehler -904 aufgetreten
What to try next ? Server documentation "Database Utilities" Chapter 20 is about old exp and imp tools. They are still supported. It says you have to install it (catexp.sql). But this is not needed, the Oracle 10G setup already installed the required exp/imp dictionary tables.
finally a exp (exp version 9.0.2) on DB 9.2 to a dumpfile and an imp (10G) into Oracle 10G worked fine.
First approach:
9.2 Schema export with "exp", then dumpfile import using Data Pump. Oracle documentation ("Oracle 10g Database Utilities" Manual) says Data Pump does not support old dumpfiles (exp generated).
Second approach:
Data Pump supports a direct export-import via network (Database link) without dumpfile generation.
>impdp mydata/no NETWORK_LINK=mydb3e.world SCHEMAS=KNO_DATA CONTENT=METADATA_ONLY
Import: Release 10.1.0.2.0 - Production on Montag, 23 August, 2004 13:56
Copyright (c) 2003, Oracle. All rights reserved.
Angemeldet bei: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining options
ORA-39006: Interner Fehler
ORA-39022: Datenbankversion 9.2.0.4.0 wird nicht unterst³tzt.
Third try:
Data Pump export (expdp) to a dump file, then impdp into 10G.
>EXPDP mydata/no NETWORK_LINK=mydb3e.world DUMPFILE=dpump_dir:no3enodata.dmp SCHEMAS=MYDATA CONTENT=METADATA_ONLY
Export: Release 10.1.0.2.0 - Production on Montag, 23 August, 2004 14:11
Copyright (c) 2003, Oracle. All rights reserved.
Angemeldet bei: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining options
ORA-39006: Interner Fehler
ORA-39065: Unerwartete Master-Prozess-Exception in DISPATCH
ORA-00904: "SYS"."KUPM$MCP"."GET_ENDIANNESS": ung³ltiger Bezeichner
ORA-39097: Bei Data Pump-Job ist ein unerwarteter Fehler -904 aufgetreten
What to try next ? Server documentation "Database Utilities" Chapter 20 is about old exp and imp tools. They are still supported. It says you have to install it (catexp.sql). But this is not needed, the Oracle 10G setup already installed the required exp/imp dictionary tables.
finally a exp (exp version 9.0.2) on DB 9.2 to a dumpfile and an imp (10G) into Oracle 10G worked fine.
0 Comments:
Kommentar veröffentlichen
<< Home