Re: Questions re datapump import

From: Jost, <>
Date: Thu, 19 Nov 2009 14:02:00 +0100
Message-Id: <1258635720.12495.9.camel_at_jost-laptop>

On Thu, 2009-11-19 at 12:52 +0000, John Dunn wrote:
> I want to use datapump export and import as simple method of backing
> up schemas in our development environments.
> i.e. to restore the schema to a previous state, I would import back
> into the same schema.
> If I do a full schema import using datapump, will the fact that the
> database objects already exist cause issues? Will data rows in tables
> be duplicated?
> Or is there a better way of backing up and restoreing a single schema?


you are able to control the import process via a lot of configuration variables.

Especially table_exist_action may be worth a look.

You can drop or truncate the table in front of the import process to reach your goal. There are even more possibilities, so try

Jörg Jost

Received on Thu Nov 19 2009 - 07:02:00 CST

Original text of this message