Oracle 9i to 10g migration using exp / imp
I have two different Servers
Server A: Linux OS with 9i
Server B: Linux OS with 10g
I want to make a full migration from 9i to 10g; the database is not too large.
i. how do i ftp the dmp files from one server to another.
ii. How do i use exp/imp efficiently to migrate 9i DB to 10g.
If there is another solution please elucidate it too.
Server A: Linux OS with 9i
Server B: Linux OS with 10g
I want to make a full migration from 9i to 10g; the database is not too large.
i. how do i ftp the dmp files from one server to another.
ii. How do i use exp/imp efficiently to migrate 9i DB to 10g.
If there is another solution please elucidate it too.
Last Comment
ASKER
Hi,
what do u mean by 'remember not all source object will take participate in exp file'.
what do i have to do on the destination db(10g). do you think i will have to create tablespaces?
what do u mean by 'remember not all source object will take participate in exp file'.
what do i have to do on the destination db(10g). do you think i will have to create tablespaces?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
on the 10g server do i have to log in with system or oracle?
ASKER
to be precise what i m asking is:
on the 10g, do i have to
imp system/<password>@<sid> full=y file=<same as above>
OR
imp oracle/<password>@<sid> full=y file=<same as above>
on the 10g, do i have to
imp system/<password>@<sid> full=y file=<same as above>
OR
imp oracle/<password>@<sid> full=y file=<same as above>
You can only run exp/imp as a database user. oracle is usually an OS user unless you do have a database user called oracle who has the appropriate export/import privileges. This is why I tend to use system.
Another solution - use a link between the two servers and load the tables that way.
presuming there's a reason to not upgrade the 1st server from 9i to 10g,
1. use exp/imp
2. copy data over db link (CREATE TABLE as SELECT)
and to clarify the transportable tablespaces idea .. upgrade the 9i instance to 10g, then use transportable tablespaces. , or datapump for that matter.
presuming there's a reason to not upgrade the 1st server from 9i to 10g,
1. use exp/imp
2. copy data over db link (CREATE TABLE as SELECT)
and to clarify the transportable tablespaces idea .. upgrade the 9i instance to 10g, then use transportable tablespaces. , or datapump for that matter.
ASKER
hi dbadirect,
can u further gimme details of linking two servers?
a link or tutorial?
can u further gimme details of linking two servers?
a link or tutorial?
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
exp full=y file=file_name.dmp userid =finance/fin@hcl
be sure above user must be present at destinaition.
to transfer this file from one os to another os or machine use ftp
ftp 192.9.200.10
type the username (do not use root rather use oracle)
type password
type binary --- to set the tranformation in binary stream
get file_name.dmp
type bye