DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: import new records

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    import new records

    hi,
    I've a export file (x.dmp) where there are four tables:
    Table A
    Table B
    Table C
    Table D

    A,B,C,D are present in my db, but in file dmp there are new records that aren't in my tables.

    How can I import this records without before drop tables?

    import system/manager@mydb file=x.dmp fromuser=tom touser=tom .....................

    Thanks
    Raf

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Use ignore=y parameter while importing
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    You may want to truncate those tables prior to the import, of course you will loose all old data.

    MH
    I remember when this place was cool.

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