Re: oracle 9 export all without 1 table

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Mon, 2 Mar 2009 07:44:50 -0800 (PST)
Message-ID: <378db2ba-ef6c-4218-a1c8-bb2f5a14c1f6_at_a39g2000yqc.googlegroups.com>

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.
>
> -g

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 rows

exported
Export terminated successfully without warnings.

UT1 > drop table marktest2;

Table dropped.

JServer Release 9.2.0.6.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set
. 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)                  LOGGING

NOCOMPR"
 "ESS"

. . importing table                    "MARKTEST2"       4999 rows

imported
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