Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alternative to EXP/IMP
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
In addition to Jim and Mark's suggestions, there are a host of tools that will extract DDL from an existing schema to a text file. You could use one of those, edit the file if necessary, and run it on the 2nd machine. Just a few that will do this...
TOAD
SqlNavigator
Schema Manager
You can also run a norows export, grep out the "CREATE" lines and
save them into a different files. Like the old saying says, there's
more than one way to skin a cat.
- --
Chuck Hamilton
chuck_hamilton_at_yahoo.com
"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
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
iQA/AwUBO7HfEmm5A4kkb4ZsEQIPUQCeKhbR5Il8Zuuk2PEoPHFeLkWbPuMAn0NM
rzHnq5Oxf0v+mibGHyrip0kP
=YFbX
-----END PGP SIGNATURE-----
Received on Wed Sep 26 2001 - 08:58:47 CDT