Re: Newbie help: Import/Export caveats

if you need to see the help for export or import type: exp help=Y
for export there is a parameter called inctype with COMPLETE being the default
there are two other options
CUMULATIVE - if you did a full export previously then this can be specified. only those tables that contain rows that have changed since the last Full export of any type will be exported. INCREMENTAL - If FULL=Y, then this can be specified. This option exports all tables whose rows have changed since the last Cumulative or Complete export.

Try this out maybe it will help. You might have to disable constraints and the such.
If you want to do it with minimal hassle drop all of your tables with cascade constraints and do a full import. If the database isn't up and running yet then time won't be a concern.

hth

mike

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 04 2000 - 13:12:02 CST