Questions re datapump import
From: John Dunn <JDunn_at_sefas.com>
Date: Thu, 19 Nov 2009 12:52:11 -0000
Message-ID: <2F802216565E44489600A03F763219A8751589_at_mia.SEFASBRISTOL>
I want to use datapump export and import as simple method of backing up schemas in our development environments.
Date: Thu, 19 Nov 2009 12:52:11 -0000
Message-ID: <2F802216565E44489600A03F763219A8751589_at_mia.SEFASBRISTOL>
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?
I do not want to drop the schema between doing the export and the import.
John
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 19 2009 - 06:52:11 CST