| Problem while importing data... [message #397771] |
Mon, 13 April 2009 17:13  |
shekharnegi12
Messages: 52
Registered: October 2008
|
Member |
|
|
Hello,
I'm performing an import to a DB using the following code
impdp system/password@test1 full=Y directory=dumptest dumpfile=full.dmp logfile=impdpDB10G.log TABLE_EXISTS_ACTION=append
While importing I got the following error:
ORA-39152: Table "SYSTEM"."table_name" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
ORA-39152: Table "SYSMAN"."table_name1" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
This happened for many rows and then came a new error:
ORA-31693: Table data object "Schema_name"."table_name" failed to load/unload and is being skipped due to error:
ORA-00001: unique constraint (Schema_name.1234) violated
Can someone please tell me why is this happening? I did some research and found out that people have mentioned that while exporting we should use the content=All parameter, but I already have Full=Y paramter in here. Any input will be appreciated.
Thanks,
SN
|
|
|
|
| Re: Problem while importing data... [message #397772 is a reply to message #397771] |
Mon, 13 April 2009 17:17  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>ORA-00001: unique constraint (Schema_name.1234) violated
You are trying to insert a record into a table that is
protected by a unique/primary constraint.
Since the record to be inserted already exists, it will error out.
You need to "clean" the data before import.
[Updated on: Mon, 13 April 2009 17:18] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Problem while importing data... [message #398007 is a reply to message #397771] |
Tue, 14 April 2009 16:26 |
shekharnegi12
Messages: 52
Registered: October 2008
|
Member |
|
|
Mahesh thank you so much! It worked!
Have you come across a issue where whenever you perform a restore it restores the same data again and again. So whenever I select "current_scn" it never is up to date? I tried control file over from the production DB over to test and re tried the restore but no luck.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Problem while importing data... [message #436013 is a reply to message #435987] |
Mon, 21 December 2009 01:37 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Thank you for what? He just thanked people and asked a new question!
Or are you just answering to put your email and get ready for thousand spam?
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
