Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Alternative to EXP/IMP
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 - 03:43:39 CDT