Re: oracle 9 export all without 1 table
Date: Mon, 2 Mar 2009 07:44:50 -0800 (PST)
On Mar 2, 10:24 am, gar..._at_jamms.org wrote:
> On 2 Mar, 14:17, ddf <orat..._at_msn.com> wrote:
> > Which will cause the import to fail at that point and any table listed
> > after that fatal error won't be imported.
> > David Fitzjarrell
> Are you sure? In my experience, the import will fail on the
> precreated table and continue afterwards normally.
My experience is also that if a single DDL fails in the import because the table already exist the import will continue to the next table. The import will end with warning but only after completing the rest of the import file.
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table MARKTEST 5 rows exported . . exporting table MARKTEST2 4999 rowsexported
Export terminated successfully without warnings.
UT1 > drop table marktest2;
JServer Release 188.8.131.52.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character
. importing MPOWEL01's objects into MPOWEL01 IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "MARKTEST" ("FLD1" VARCHAR2(10), "FLD2" NUMBER, "FLD3" DATE, ""
"FLD4" VARCHAR2(40)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE("
"INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 128 PCTINCREASE 0 FREELIST"
"S 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGINGNOCOMPR"
. . importing table "MARKTEST2" 4999 rowsimported
Import terminated successfully with warnings. $
As can be seen from the example imp skips over the failing table and continues.
HTH -- Mark D Powell -- Received on Mon Mar 02 2009 - 09:44:50 CST