This discussion is archived
4 Replies Latest reply: Mar 3, 2013 1:51 PM by Dean Gagne RSS

ignore=y in full export or import

927253 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points