HI all Can you tell how to import data from oracle 10g to Oracle 9i. Is it ok i can export the data from Oracle 10g and import it to 9i directly, it should work??? or i need to follow some other procedure???
Kindly help me Thanks in advance Joseph
+1
A:
You should be able to do the export using the usual exp / imp commands to perform the transfer.
kdmurray
2009-03-26 08:28:59
Thanks Buddy, il check the details
Joseph
2009-03-26 09:33:41
A:
You can also create a database link between the databases. exp / imp is faster but a database link makes it possible to do continuous export / import.
tuinstoel
2009-03-26 08:35:09
+5
A:
Exp and Imp are the best way to go for a single data move. I would second the suggestion of database links if you need to have continuous access to the data.
One problem is the files produced by imp and exp are not backwardly compatible. That is if you use the 10g version of exp to create a dump file, you can't use the 9i version of imp to import the data.
In this case you need to use the 9i version of exp, connected to the 10g database, then use the 9i version of imp to import the data.
Thomas Jones-Low
2009-03-31 13:49:48