Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: 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 tables=A file=x.dmp fromuser=tom touser=tom .....................

    Thanks
    Raf

  2. #2
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    44

    Re: import new records

    Use option ignore=Y to avoid errors cased by existence of the tables.

    Originally posted by raf
    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 tables=A file=x.dmp fromuser=tom touser=tom .....................

    Thanks
    Raf

Posting Permissions

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