Yesterday, I want to migrate the database on my machine to a dedicated server. The local Oracle10g is installed, and the database installed on the server is Oracle9i. I will first perform the following operations: export the database file locally: exp gzwp/wlkp @ taxser file = d: \ 20130226.dmp owner = gzwp get the Server Import: imp gzwp/wlkp @ taxser file = d: \ 20130226.dmp fromuser = gzwp touser = gzwp ignore = y error:
IMP-00010: the exported file is not valid and title verification fails.
IMP-00000: Import failedThe reason is that the database version is incorrect. Oracle does not support importing a later version to a later version.. Solution:
1. configure an Oracle database on the server to connect to the local Oracle10g (called taxser134) by using the help tool Net Manager provided by oracle or modifying tnsname. tra9i Directory: % oracle_home % \ ora92 \ network \ admin, 10 Gb Directory: % oracle_home % \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN)
Export the database file exp gzwp/wlkp @ taxser134 file = d: \ 20130226.dmp owner = gzwp 2. create a database, user, and tablespace on the remote server: 1>. you can use the oracle tool Database Configuration Assistant to create a Database instance (ntaxser ):
Note that the selected character set corresponds to the local database; otherwise, Chinese characters may be garbled. 2>. sqlplus sys/wlkp as sysdbacreate user gzwp identified by wlkp; grant connect, resource, dba, create session to gzwp; create tablespace WLKPTABLE
Logging
Datafile 'f: \ oracle \ product \ 10.1.0 \ oradata \ ntaxser \ WLKPTABLE. dbf'
Size 50 m
Autoextend on
Next 50 m maxsize 20480 m
Extent management local ;//....... all tablespaces used 3. import the file to the server: imp gzwp/wlkp @ ntaxser file = d: \ 20130226.dmp fromuser = gzwp touser = gzwp ignore = y. Import successful! In fact, all solutions for migrating oracle databases from a later version to a later version are similar: configure a connection to a later version of the database on an earlier version of Oracle, use the earlier version of the oracle client to export data files and then import them.
This article from the "wolf" blog, please be sure to keep this source http://yangfei520.blog.51cto.com/1041581/1141135