RE: [Non-DoD Source] Re: Export Import Question
Date: Mon, 21 Mar 2016 10:43:57 +0000
Message-ID: <85D44D05C4C24C40AFDED6C1FC0E1BDFD1A93DA7_at_SNSLCVWEXCH02.abl.cda.navy.mil>
Sorry, we did get it solved. The problem was the roles of the exporting user and import user weren't consistent. It went beyond DBA. The person who prepared the load used a different database image to prepare the load than used up till this point. Adding DBA to the importing user still gave an error. The other differences were export_full_database, Import_full_database, resource (unlimited tablespace). There just weren't enough error messages. Things can usually be sorted out if you have enough time....it's getting enough time that's the trick.
Donald Freeman
Systems Dev Spec, Principle
ManTech International
(757)852-6690 (w)
(717-497-1037 (C)
(757)-852-7777 PMO-IT Help Desk
RHR Facility
donald.freeman_at_mantech.com
donald.freeman.ctr_at_ablcda.navy.mil
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
Behalf Of Jack van Zanen
Sent: Monday, March 21, 2016 6:34 AM
To: Freeman, Donald G. CTR
Cc: Oracle-L_at_freelists.org
Subject: [Non-DoD Source] Re: Export Import Question
been over a week....but if not yet solved, can you give the exact exp parfile and imp parfile (hash out the passwords and other sensitive data)
Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
On Sun, Mar 13, 2016 at 7:09 AM, Freeman, Donald G. CTR <donald.freeman.ctr_at_ablcda.navy.mil> wrote:
I'm not doing a lot of hands on DBA work anymore so I'm having a problem with something I probably should know. Here is the situation: We received our monthly export .dmp file (from exp not datapump) from our development team that was exported by Scott. Apparently in development Scott has the DBA role. We are trying to import it as user Scott on a production database where Scott does not have DBA role. I'm getting the error, "Warning: the objects were exported by Scott, not by you." I'm thinking the developer has granted the user DBA to make his life easier and overcome some problem but the production system has no such role assigned to Scott. When we granted it just to get through the import it didn't work either. We still get that error. What do I have to do to fix this? I did check the import file and it was exported by Scott. I had thought they made a mistake and exported it as sys but, no. Would the difference in roles on development and prod show up as the user being a different user? It worked last month. Donald Freeman Systems Dev Spec, Principle
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 21 2016 - 11:43:57 CET
- application/pkcs7-signature attachment: smime.p7s