| export to diffrent server with diffrent version [message #73105] |
Tue, 03 February 2004 04:56  |
rajitha
Messages: 19
Registered: July 2002
|
Junior Member |
|
|
i want to export to diffrent server a user level export.How can we export from oracle 8.1.7 to oracle 9.2 And how can we import to this lateast version.normal export import or anything we have to take care about just like indexes
its on different server can any one give an sample script to do it.
with regards
rajitha
|
|
|
|
| Re: export to diffrent server with diffrent version [message #73106 is a reply to message #73105] |
Tue, 03 February 2004 05:04  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
always do the export from sourceDB using lower version exp tool
and
always do the import to the targeDB using the same lower version of the imp tool.
so
in host1, where 8i is installed,
-- do the export.
1. exp dbauser/pass owner=scott file=scott.dmp
-- create a tnsconnectstring to connect to other database in host2 where 9i is installed
-- let the connect string be otherdb
-- first create the tablespace and user in 9i db
-- do the import
2. imp dbauser/pass@otherdb fromuser=scott touser=scott
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
