impdp error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: impdp error

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    impdp error

    Anybody have a clue as what the error below means on the an impdp


    Copyright (c) 2003, 2007, Oracle. All rights reserved.
    ;;;
    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
    Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    Master table "ORACLE"."SYS_IMPORT_FULL_04" successfully loaded/unloaded
    Starting "ORACLE"."SYS_IMPORT_FULL_04": /******** directory=dsp dumpfile=mtas_2
    0101021.dmp
    Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
    ORA-31696: unable to export/import TABLE_DATA:"MTAS"."MTAS_HISTORY":"HISTORY_201
    01021" using client specified AUTOMATIC method



    I exported the following partitions from a table here is my parfile.

    directory=DATA_PUMP
    dumpfile=mtas_20101021.dmp
    logfile=mtas_20101021.log
    content=DATA_ONLY
    tables=MTAS.MTAS_HISTORY:HISTORY_20101021,MTAS.MTAS_REQ:REQ_20101021,MTAS.MTAS_RESULT:RESULT_2010102 1


    During the import, the exact partitions names exist on the target and the tables are the same.

    Here is my import command

    impdp / directory=dsp dumpfile=mtas_20101021.dmp TABLE_EXISTS_ACTION=APPEND

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    is all the partitions / sub-partitions exists in target? Is the table space names are same in both the data bases?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Feb 2009
    Posts
    91
    It took alot of digging but I found the problem, one of the indexes was marked 'UNUSABLE'. I rebuilt the index and the import worked.

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Thanks for sharing Paul.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Feb 2009
    Posts
    91
    NP I am all for sharing the knowledge

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width