Re: Questions re datapump import
From: Jost, <Joerg.Jost_at_unitrade.com>
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?
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?
Hi,
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 http://download.oracle.com/docs/cd/E11882_01/server.112/e10701/dp_import.htm#i1007653
hth
J�rg Jost
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 19 2009 - 07:02:00 CST