1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

IMP error in 11g

Discussion in 'General' started by akhilmohan, Jul 16, 2011.

  1. akhilmohan

    akhilmohan Guest

    Scenario :expfrom 10g to imp to 11g databse .Error :the databasde does not exist .I Know usually while importing it will look through the default tablespace of touser.But it is trying to create the object with the same tablespace as source databse.I have given ignore=y option and the table does not contain any long or blob datatype field .We can use datapump for avoiding this .But just curious to know by exp imp ??
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    What does this mean? The error says 'database does not exist'? How then did you connect and attempt an import?
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    I think, there is a typo. The error should be "ORA-00959: tablespace 'xxxxxxx' does not exist". Please refer the following
    Asktom link