Just use the version of exp and imp that is on the lower version. That will
work. You are right going from a higher version to a lower version may not
work. However using the exp and imp tools from 8.1.6 to create the dmp file
while attaching to an 8.1.7 database works. The resulting file can be
imported into 8.1.6. It is easier than your current plan.
Jim
"Richard Shea" <rshea_at_my-deja.com> wrote in message
news:43160f6f.0109260043.61adffb2_at_posting.google.com...
> Hi - I'm looking at alternatives to EXP/IMP when moving a schema/data
> from one box to another (this is because I've got the schema/data on a
> higher version of Oracle then the target machine has, 8.1.7 is trying
> to go to 8.1.6).
>
> My current plan is :
>
> SCHEMA:
> 1. EXP rows=N
> 2. IMP INDEXFILE="something.sql"
> 3. Take the REM lines out of something.sql
> 4. run the something.sql on the target machine
>
> DATA:
> 1. Dump data to comma delimited files
> 2. Use SQLLDR to load comma delimited files to target database
>
> Haven't tried any of it yet, but I'll have to in the morning. Any
> Oracle gurus want to suggest a better idea ?
>
> regards
>
> richard shea.
> rshea_at_my-deja.com
Received on Wed Sep 26 2001 - 07:14:29 CDT
