I dont think there are differences in exp and imp between Oracle maintenance
releases.
hth
Lawrence
"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:42:29 CDT
