Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Unanswered: hey this is regarding imp from db1 to db2

    i want to import records from db1 table to db2
    imp system/manager@db1 file=full.dmp fromuser=scott touser=scott
    tables=company commit=y indexes=n ingnore=y
    gives no error successfully completed i saw log also.
    but in db2 in the company table getting no rows selected ,issue is imp can help me

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    Quote Originally Posted by kavita pathrikar
    gives no error successfully completed i saw log also.
    It is a pity that I am unable to see your log .
    Do you really expect any meaningful answer without providing it?

  3. #3
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85

    some is wrong

    ""
    i want to import records from db1 table to db2
    imp system/manager@db1 file=full.dmp fromuser=scott touser=scott
    tables=company commit=y indexes=n ingnore=y
    gives no error successfully completed i saw log also.
    but in db2 in the company table getting no rows selected...
    ""
    you must invoke imp on db2
    Beer contains just a small amount of vitamines - that's why it's necessary to drink lot of it.

Posting Permissions

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