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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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