Re: Alternative to EXP/IMP

Hi,

I think you should use exp/imp for this task, but as an alternative take a look at Chyfo (www.ispirer.com/products/). It can easy dump data to text files, generates DDL scripts (for tables, indexes, constraints, views) and control files for SQL Loader.
It can move data not only between Oracle databases. DB2, MS SQL are also supported.
It is easy to use:

chyfopro /d=ora_base /u=usr /p=pwd /t=*.* /target=ora

Best regards, Dmitry

"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 Thu Sep 27 2001 - 05:11:51 CDT