Re: oracle 9 export all without 1 table

From: ddf <oratune_at_msn.com>
Date: Mon, 2 Mar 2009 08:14:34 -0800 (PST)
Message-ID: <ffbc220d-196e-4354-afda-4ba733b60794_at_n33g2000vba.googlegroups.com>

On Mar 2, 9:44 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> 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 --

I appreciate the correction; apparently imp and exp have improved over the years.

David Fitzjarrell Received on Mon Mar 02 2009 - 10:14:34 CST