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

Hybrid View

  1. #1
    Join Date
    Mar 2001

    Red face Import Data Problem

    I have ORACLE Ver. 7.3.

    I exported data by using "exp73.exe usename/password file=location" from dos.

    When I use "imp73.exe username/password file=location" to import data than messages come "Table already exists Skip table", "import terminated successfully."

    I need some help about import this database which replace older database in that user.
    Yogesh Bhardwaj

  2. #2
    Join Date
    Apr 2001


    when u are importing using imp73 username=username/password file=location u will get error if the objects that u are importing exists in the database so try to use this command

    imp73 username=username/password file=location ignore=y

    try this out

  3. #3
    Join Date
    Apr 2001

    Lightbulb import

    imp73 username=username/password file=location ignore=y

    Ignore = y option ignores the create error messages and inserts all the rows into the existing tables..

    But How can we import into existing tables and overwrite old rows with new rows which is in the dump file(import file).


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.