IMP-0003, ORA-01435 Errors while importing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: IMP-0003, ORA-01435 Errors while importing

  1. #1
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409

    IMP-0003, ORA-01435 Errors while importing

    While trying to do user level import with following :

    imp system/password@testdb file=test.dmp fromuser=test touser=test

    am getting IMP-00017 and ORA-01435 Errors. The error says that user does not exists. Whereas the user 'test' does exists.

    Any thoughts/pointers on this? Thanks.
    -- Dilip

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Just did windows reboot and the above import ran fine without any errors. Just to let you all know.

    Thanks
    -- Dilip

  3. #3
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Should be a problem of setting ORACLE_SID I guess
    -nagarjuna

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Thanks Nagarjuna. There was only one database instance on this machine. Does ORACLE_SID setting still matter in this case? I did the above steps number of times before but never had this problems. I happen to reboot the machine and it worked fine.

    Thanks.
    -- Dilip

  5. #5
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by patel_dil
    Thanks Nagarjuna. There was only one database instance on this machine. Does ORACLE_SID setting still matter in this case? I did the above steps number of times before but never had this problems. I happen to reboot the machine and it worked fine.

    Thanks.
    Oooooops.. my answer was wrong.. You have given perfect command for import with connect string attached. No idea as why this import failed before.
    -nagarjuna

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