Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Alternative to EXP/IMP

Alternative to EXP/IMP

From: Richard Shea <rshea_at_my-deja.com>
Date: 26 Sep 2001 01:43:39 -0700
Message-ID: <43160f6f.0109260043.61adffb2@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 - 03:43:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US