Hi there
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?
Import/Export?
SQL*Loader?
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????
Are you moving the data from 8i to 9i just once to get things set up, or will this be an ongoing operation? If you are doing it once, I think export/import is the easiest way. The import will create all of the schema objects needed, if they are not already created. If you are going to be transporting data back and forth between instances on a regular basis, your best bet may be to set up a database link between the two, and run 'insert into tablea select columns from tableb'. As long as both servers are defined in DNS, that should not be a problem. SQLNET 8i is compatible with ORACLE9I and vice-versa.
As for supported datatypes, check the Oracle documentation. 9i may intorduce some new datatypes not used 8i, but I can't be sure.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 1  Reply