Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2010
    Posts
    81

    Unanswered: Oracle Import failure - ORA2270

    Hello,

    Yesterday I took an export and reimported to a different database, but I noticed the object count was different.
    During the import I noticed errors with the foriegn and primary keys. I have a number of imports to do and wondered
    what I can do to not recieve these errors again. My import command was as follows:-

    imp owner=schema file = schema_export.dmp log=schema.log statistics=none buffer = 52428800 feedback = 5000

    The object count on the source database was 1102 and in the target database it was 1091. A difference of
    11 objects. There were no inavlid objects. I have read that maybe I should have imported without indexes or constraints
    but this I do not understand as easily. Can someone shed some light or provide me with the correct syntax to use

    Many thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I do not understand as easily
    Are the missing objects owned by "schema"?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2010
    Posts
    81
    Yes,

    the missing objects are owned by the same schema. This is just a standard export from the same user to the same user however on a different database and different server. I used the term 'schema' which is actually the schema owner. Like Fred or Harry. Just an example

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > log=schema.log
    If missing objects are owned by "schema", then log file above should contain explanation regarding what happened to them during the import
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2010
    Posts
    81
    Apologies,

    I should have mentioned that there was NO log file taken during the import. There should have been but on this occassion there was none.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >>imp owner=schema file = schema_export.dmp log=schema.log
    >I should have mentioned that there was NO log file taken during the import.

    I don't know what to believe, so won't waste more time trying solve this mystery
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jun 2010
    Posts
    81
    If you cannot answer the question just say so.

    I have an import with those errors. Its clear to see whether there is a log file or not. Normally I would have added a log file with that command, but on this occassion there is not one. however the error still remains. If you can help, please do so, and if you cannot please do not add to the question as it uneccessary to add those comments to people who are trying to learn and may not be as technical and gifted as your fine self

    Many thanks

Posting Permissions

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