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

Thread: Problem Importing Data

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    5

    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
    Posts
    3

    Hi,

    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
    suren

  3. #3
    Join Date
    Apr 2001
    Posts
    1

    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).

    Regards
    Saravana




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