| Populating Data between 2 different Servers and DB [message #161400] |
Fri, 03 March 2006 14:43  |
faiz_hyd
Messages: 294
Registered: February 2006
|
Senior Member |
|
|
Hi
I am stuck in this case , Please experts give some advices.
Unix Server 1 ip address 1.2.3.4 Oracle Version 9.2.0.5 Schema:-ABC TAble TEST.
Unix Server 2 ip address 5.6.7.8 Oracle Version 8.1.7 Schema: -CDE TAble TEST(same Structure as above table).
Our task is to daily insert data from Server1 table(9i) into Server2 Table(8.0), daily at 7 PM.
First attempt we tried Export / Import it failed becz of version difference and message
Character Conversion problem came.
1 export in 9i and then import in 8i then message NOT A VALID EXPORT FILE.
2 export in 8.0 using remote connection and connecting 9i then importing in 8.0 then
message CORE DUMP
Another attempt using Remote Database connection failed because of character conversion and and we want it daily .
We want to make it a cron job so that daily at 7 PM it should load data into another table.
Or else somebody gave idea to make a control file and use SQL Loader for daily, how can we set it..
Any ideas or steps is requested.
Thanks
|
|
|
|
| Re: Populating Data between 2 different Servers and DB [message #161404 is a reply to message #161400] |
Fri, 03 March 2006 15:53  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
| Quote: |
1 export in 9i and then import in 8i then message NOT A VALID EXPORT FILE.
2 export in 8.0 using remote connection and connecting 9i then importing in 8.0 then
message CORE DUMP
|
You need to provide specific, exact errors message for proper diagnostics. Posting like above helps nothing.
Search the board. Situtations like have been discussed a zillion times.
Use lower version of exp (8i) to export from higher version (9i).
Use the same lower version imp (8i) to import into target database.
or
Install 9i exp/imp views in 8i by running catexp.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
