10g to 9i?

Hi Friends,

We made the mistake of using our 10g instance for some serious data entry and found our client is on 9i and has no intentions of upgrading. I was able to search the net and find it is possible to use a dmp from 10g to 9i, however the method using a 9i exp.exe file in 10g to create the correct binary dump has failed. Does anyone know how else this is possible?

Thanks a lot
Greg


"It is difficult to free fools from the chains they revere".
-Voltaire

yes, you use the 9i exp against the 10g database - if you are having issues with doing them post them specifically

hi friend, u can use dblinks to copy data to 9i or spool to .csv and load it to 9i

10g data > flat file > sql loader, dump in 9i.

Otherwise post your errors.....

Quote:

---

Originally Posted by dbasan

10g data > flat file > sql loader, dump in 9i.

---

Flat file creation is easy with, IxUnload: see www.ixionsoftware.com ;)

Then use sqldr on your 9i system to reload the data. For large amounts of data, sql Loader (direct) is faster.

Quote:

---

Originally Posted by ixion

Flat file creation is easy with, IxUnload: see www.ixionsoftware.com ;)

---

It might be easier, but it's also more expensive, I'd say.

I wonder, why after the most elegant, most cost effective and most "native" solution has allready been proposed (i.e. davey23uk's suggestion to use 9i exp utility for export from 10g database and then 9i imp to imort into 9i database), new and new "smart" suggestions keep popping up..... :confused:

But hey, why do it simple and efficient when you can do it complicated and convoluted.... :rolleyes:

yeah Jurij...its funny :D they are just a variation to my suggestion.
Anyways what u think is simple may look complicated to others
and vice versa :p

davey23uk is right

I have the same scenario.

I have installed oracle 9i client on one of my machine and tacking export of 10g using 9i exp file.

Quote:

---

Originally Posted by jmodic

It might be easier, but it's also more expensive, I'd say.

---

More Expensive is a relative term wouldn't you say?

In this case I'd certainly use a dblink.. simple and easy for small data sets. I was mainly responding to dbasans post about a "flat file".

Export/import is fine for "small" data. But when it comes to large data loading nothing beats sqlldr VAR formatted data. Thats where this product fits nicely (sqlplus won't be able to create that type of file).

regards.

with gfgst2's case, i dnt think the db has grown huge. So I still go with exp/imp using 9i. If you see error like statistics related, just ignore it.

Thank you to everyone please forgive such a late reply. As Davey23uk had suggested, I used the 9i instance against the 10g box over the network and imported just fine.

Thank you again.