I have 2 Oracle DB
A) Oracle 9i running on W2K, IPAddr=IP1, SubnetMask = SN1
B) Oracle 8i running on Solaris 2.6, IPAddr = IP2, SubnetMask = SN2
I now need to transfer some data from oracle 8i (solaris) to oracle 9i (win 2k)(the 2 servers being configured with different IP and in different subnet mask, with different OS and different oracle version). What is the best option I could use?
extract to a file (txt, excel), etc then import????
Also, if I need to transfer the updated data periodically from 9i (win2k) into 8i (solaris), what is the best way to achieve this? Create an auto-job to run a SQL script on my Solaris box?
There are some data types not supported in 8i, what do I have to look out for? Any way to detect which are the data types not supported in 8I during the Import function?
Basically, I am thinking that if I create the same table structure that is used to store the data in 9i (win2k) as per 8i (solaris), I shld be "safe" as users will be updating the data on 9i (win 2k), but won't be updating the data on 8i (solaris), as my 8i is for data warehousing (inquiry only)
But, problem is when I am creating new tables in 9i (win2k), I need to be careful regarding the data types definition, which I can't used on 8i. Can anyone just gave me a list of what are the not supported data type in 8I vs 9I????