Re: Alternative to EXP/IMP

Don't know if it is a better idea, but a different idea would be to create the clone table as a copy from the original. This could be scripted one of two ways

copy fromuser userid/password_at_original touser u2/p2 create clone using
select * from t1; (SQLNET copy, syntax close if not correct.)

create table clone as
select * from parent_at_original.world.

These won't get the indexes, triggers, etc. but will move the data. Triggers and indexes can be retrieved from the source files ( :} ) or from the indexfile option of an export/import.

rshea_at_my-deja.com (Richard Shea) 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 - 11:06:10 CDT