4 Replies Latest reply: Mar 3, 2013 3:51 PM by Dean Gagne-Oracle RSS

    ignore=y in full export or import

    927253
      what is ignore=y in import n export. Do we not to use in full export or import
        • 1. Re: ignore=y in full export or import
          sb92075
          924250 wrote:
          what is ignore=y in import n export. Do we not to use in full export or import
          [oracle@localhost trace]$ imp help=yes
          
          Import: Release 11.2.0.2.0 - Production on Sun Mar 3 11:39:54 2013
          
          Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
          
          
          
          You can let Import prompt you for parameters by entering the IMP
          command followed by your username/password:
          
               Example: IMP SCOTT/TIGER
          
          Or, you can control how Import runs by entering the IMP command followed
          by various arguments. To specify parameters, you use keywords:
          
               Format:  IMP KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
               Example: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N
                         or TABLES=(T1:P1,T1:P2), if T1 is partitioned table
          
          USERID must be the first parameter on the command line.
          
          Keyword  Description (Default)       Keyword      Description (Default)
          --------------------------------------------------------------------------
          USERID   username/password           FULL         import entire file (N)
          BUFFER   size of data buffer         FROMUSER     list of owner usernames
          FILE     input files (EXPDAT.DMP)    TOUSER       list of usernames
          SHOW     just list file contents (N) TABLES       list of table names
          IGNORE   ignore create errors (N)    RECORDLENGTH length of IO record
          GRANTS   import grants (Y)           INCTYPE      incremental import type
          INDEXES  import indexes (Y)          COMMIT       commit array insert (N)
          ROWS     import data rows (Y)        PARFILE      parameter filename
          LOG      log file of screen output   CONSTRAINTS  import constraints (Y)
          DESTROY                overwrite tablespace data file (N)
          INDEXFILE              write table/index info to specified file
          SKIP_UNUSABLE_INDEXES  skip maintenance of unusable indexes (N)
          FEEDBACK               display progress every x rows(0)
          TOID_NOVALIDATE        skip validation of specified type ids 
          FILESIZE               maximum size of each dump file
          STATISTICS             import precomputed statistics (always)
          RESUMABLE              suspend when a space related error is encountered(N)
          RESUMABLE_NAME         text string used to identify resumable statement
          RESUMABLE_TIMEOUT      wait time for RESUMABLE 
          COMPILE                compile procedures, packages, and functions (Y)
          STREAMS_CONFIGURATION  import streams general metadata (Y)
          STREAMS_INSTANTIATION  import streams instantiation metadata (N)
          DATA_ONLY              import only data (N)
          VOLSIZE                number of bytes in file on each volume of a file on tape
          
          The following keywords only apply to transportable tablespaces
          TRANSPORT_TABLESPACE import transportable tablespace metadata (N)
          TABLESPACES tablespaces to be transported into database
          DATAFILES datafiles to be transported into database
          TTS_OWNERS users that own data in the transportable tablespace set
          
          Import terminated successfully without warnings.
          [oracle@localhost trace]$ 
          • 2. Re: ignore=y in full export or import
            Srini Chavali-Oracle
            IGNORE only applies to classic import - http://docs.oracle.com/cd/E11882_01/server.112/e22490/original_import.htm#sthref2201

            HTH
            Srini
            • 3. Re: ignore=y in full export or import
              TSharma-Oracle
              IGNORE
              Default: n
              Specifies how object creation errors should be handled. If you accept the default, IGNORE=n, Import logs or displays object creation errors before continuing.
              If you specify IGNORE=y, Import overlooks object creation errors when it attempts to create database objects, and continues without reporting the errors.
              Note that only object creation errors are ignored; other errors, such as operating system, database, and SQL errors, are not ignored and may cause processing to stop.
              In situations where multiple refreshes from a single export file are done with IGNORE=y, certain objects can be created multiple times (although they will have unique system-defined names). You can prevent this for certain objects (for example, constraints) by doing an import with CONSTRAINTS=n. If you do a full import with CONSTRAINTS=n, no constraints for any tables are imported.
              If a table already exists and IGNORE=y, then rows are imported into existing tables without any errors or messages being given. You might want to import data into tables that already exist in order to use new storage parameters or because you have already created the table in a cluster.
              If a table already exists and IGNORE=n, then errors are reported and the table is skipped with no rows inserted. Also, objects dependent on tables, such as indexes, grants, and constraints, will not be created.
              Caution:
              When you import into existing tables, if no column in the table is uniquely indexed, rows could be duplicated.
              • 4. Re: ignore=y in full export or import
                Dean Gagne-Oracle
                I can't remember the translation, but since there is support for the old exp/imp parameters in data pump, this will translate into something. I think it is

                Table_exists_action=append

                Dan