Import ERROR [message #654799] |
Sat, 13 August 2016 09:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/952270faefa13f035fbbf97657d5e039?s=64&d=mm&r=g) |
abdo2203
Messages: 22 Registered: August 2016
|
Junior Member |
|
|
I have two systems PROD and TEST of managing HR
i would like to import dump file from PROD to the TEST Envirement but the import encountred errors like imp-00019 row rejected due to oracle error 1
i used this command in oracle user :
imp userid=system/password file=Dump_08_2016.dmp fromuser=grhm touser=grhm ignore=y
i got this errors :
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (GRHM.PK_H_ZONETMP) violated
Column 1 18413U
Column 2 26-JUL-2016:00:00:00
Column 3 004
Column 4 30P94
Column 5 29-JUL-2016:00:00:00
Column 6 J
Column 7 5
Column 8 SHDPHR
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (GRHM.PK_H_ZONETMP) violated
Column 1 23056G
Column 2 30-JUL-2016:00:00:00
Regards
|
|
|
Re: Import ERROR [message #654800 is a reply to message #654799] |
Sat, 13 August 2016 09:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
As you persist ignoring my request to use [code] tags, I shall ignore your posts from now on. Perhaps someone else will assist.
|
|
|
Re: Import ERROR [message #654801 is a reply to message #654799] |
Sat, 13 August 2016 10:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
So what is your actual problem?
You don't understand the error message?
You don't understand the origin of the message?
You don't know how to fix it?
When you say you import from PROD to TEST, do you mean you replace what is int TEST by PROD content or do you want to APPEND prod data to test ones?
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also take care where you post your questions, there are multiple fora, post your question in the appropriate one.
I move this topic to "Server Utilities" forum to which it belongs.
[Updated on: Sat, 13 August 2016 10:06] Report message to a moderator
|
|
|
|
|
Re: Import ERROR [message #654804 is a reply to message #654803] |
Sat, 13 August 2016 10:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/952270faefa13f035fbbf97657d5e039?s=64&d=mm&r=g) |
abdo2203
Messages: 22 Registered: August 2016
|
Junior Member |
|
|
I have two systems PROD and TEST of managing HR
i would like to import dump file from PROD to the TEST Envirement but the import encountred errors like imp-00019 row rejected due to oracle error 1
i used this command in oracle user :
imp userid=system/password file=Dump_08_2016.dmp fromuser=grhm touser=grhm ignore=y
i got this errors :
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (GRHM.PK_H_ZONETMP) violated
Column 1 18413U
Column 2 26-JUL-2016:00:00:00
Column 3 004
Column 4 30P94
Column 5 29-JUL-2016:00:00:00
Column 6 J
Column 7 5
Column 8 SHDPHR
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (GRHM.PK_H_ZONETMP) violated
Column 1 23056G
Column 2 30-JUL-2016:00:00:00
Regards
[Edit MC: please apply code tags to code, result or command line, not on all the post.]
[Updated on: Sat, 13 August 2016 10:29] by Moderator Report message to a moderator
|
|
|
Re: Import ERROR [message #654805 is a reply to message #654804] |
Sat, 13 August 2016 10:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/952270faefa13f035fbbf97657d5e039?s=64&d=mm&r=g) |
abdo2203
Messages: 22 Registered: August 2016
|
Junior Member |
|
|
Hi Michel,
So what is your actual problem?
my problem is the import not performing on the test system
You don't understand the error message?
yes
You don't understand the origin of the message?
yes
You don't know how to fix it?
yes
When you say you import from PROD to TEST, do you mean you replace what is int TEST by PROD content or do you want to APPEND prod data to test ones?
Actually the TEST System has existant information which will be replaced by the new import
regards
[Updated on: Sat, 13 August 2016 10:29] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
Re: Import ERROR [message #654811 is a reply to message #654810] |
Sat, 13 August 2016 10:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Yes (for the current command) but don't trust me, try it!
Also, as you use the old export/import and not Data Pump, you have to recreate the account before importing.
[Updated on: Sat, 13 August 2016 10:51] Report message to a moderator
|
|
|
|
|
Re: Import ERROR [message #654816 is a reply to message #654814] |
Sun, 14 August 2016 11:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You may have to generate more scripts to drop other objects: sequences, procedures, functions, packages, views.
It may be easier to generate the DDL to re-create the user and then drop him:
set ling 10000
select dbms_metadata.get_ddl('USER','GHRM') from dual;
|
|
|
|
|
|
|
Re: Import ERROR [message #654830 is a reply to message #654829] |
Mon, 15 August 2016 12:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Do not grant all privileges to a account, only grant the privileges it needs, granting all privileges makes it doing anything in your database like removing or modifying all accounts, objects and data.
Granting it all privileges is stronger than granting it DBA role.
[Updated on: Mon, 15 August 2016 12:32] Report message to a moderator
|
|
|
|
|
Re: Import ERROR [message #654833 is a reply to message #654832] |
Mon, 15 August 2016 12:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
IMP_FULL_DATABASE is like DBA, there is few differences, it can do all the things I mentioned in my previous post.
Actually, those who have IMP_FULL_DATABASE role can grant themselves DBA role.
[Updated on: Mon, 15 August 2016 12:46] Report message to a moderator
|
|
|
|
|
Re: Import ERROR [message #654877 is a reply to message #654832] |
Tue, 16 August 2016 06:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/d29f577f753cb4b873212fd5ed0da4cd?s=64&d=mm&r=g) |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
abdo2203 wrote on Mon, 15 August 2016 12:40i have revoked the privileges after teh import operation , and i granted only connect, create session, imp_full_database
Do not grant CONNECT. That is not a privilege, but a role. A named collection of privileges. And it may very well contain some very powerful privileges that your user shouldn't have. If you want yor user to be be able to connect, then just grant CREATE SESSION. And consider whether the user needs to be able to even do that. It is quite common for a schema to exist for the sole purpose of holding objects that are used by other users, and there is no need for the schema owner to even be able to log on.
|
|
|