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: expgzwp
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: expgzwp/
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. The following operations are performed at the beginning:
Export Database files locally:
Exp gzwp/wlkp @ taxser file = d: \ 20130226.dmp owner = gzwp
Import on the server:
Imp gzwp/wlkp @ taxser file = d: \ 20130226.dmp fromuser = gzwp touser = gzwp ignore = y
Error:
IMP-00010: the exported file is not valid. It is a Hong Kong Vm and the title verification fails.
IMP-00000: Import failed
The reason is that the database version is incorrect. The website space and 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. tra (9i Directory: % oracle_home % \ ora92 \ network \ admin, 10 Gb Directory: % oracle_home % \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN)
Export Database files on a remote server:
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 sysdba
Create 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. then import the data to the server:
Imp gzwp/wlkp @ ntaxser file = d: \ 20130226.dmp fromuser = gzwp touser = gzwp ignore = y
Import successful!
In fact, the Hong Kong server has a similar approach to all solutions for migrating oracle databases from a later version to a later version: By configuring a connection to a later version of Oracle, use the earlier version of the oracle client to export data files and then import them.
This article is from the "wolf" blog. Please keep this source