10g to 9i?
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
"It is difficult to free fools from the chains they revere".
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.....
"What is past is PROLOGUE"
Flat file creation is easy with, IxUnload: see www.ixionsoftware.com
Originally Posted by dbasan
Then use sqldr on your 9i system to reload the data. For large amounts of data, sql Loader (direct) is faster.
It might be easier, but it's also more expensive, I'd say.
Originally Posted by ixion
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.....
But hey, why do it simple and efficient when you can do it complicated and convoluted....
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
yeah Jurij...its funny they are just a variation to my suggestion.
Anyways what u think is simple may look complicated to others
and vice versa
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.
More Expensive is a relative term wouldn't you say?
Originally Posted by jmodic
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).
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.
Click Here to Expand Forum to Full Width