Re: Loading data from oracle 8i to 10g

On Wed, 26 Jan 2005 11:11:18 -0000, "Ben Rum" <bundyrum75_at_yahoo.com> wrote:

>Newby alert - coming from MS SQL background (hisss..)
>
>Are there any issues loading data from an 8i database directly to a 10g
>database? I'm guessing this is done via SQL Loader?
>
>Also, the Oracle 8i instance is Enterprise Edition - I am told that the 10g
>instance MUST be Enterprise Edition for this to be done? Would
>Personal/Standard Edition not suffice?
>
>I'm not able to find any docs on www.oracle.com covering this, any pointers
>would be appreciated.
>
>Many thanks,
>

Whoever told you that the 10g must be EE needs to check his facts.

There's not such thing a db pulling data directly from another via SQL Loader. SQL Loader loads data into a db from a flat, delimited file.

Poking around www.oracle.com will be a bit difficult to find the relevent docs. What you are looking for is at tahiti.oracle.com, where you will find the complete doc set in both html and pdf format. It will require signing up for an OTN (Oracle Technology Network) account, but that is free.

Sounds to me like you want to have the 10g db get selected data directly from the 8i db. I'd think a database link would be your friend.
Thanks.

• Ed Stevens

Cohn's Law: The more time you spend in reporting on what you are doing, the less time you have to do anything. Stability is achieved when you spend all your time doing nothing but reporting on the nothing you are doing. Received on Wed Jan 26 2005 - 07:53:56 CST