| Import restoration to the same table [message #225334] |
Mon, 19 March 2007 13:22  |
rookiedba
Messages: 11
Registered: March 2007
Location: Montana
|
Junior Member |
|
|
HI there all, I am a rookie DBA and need some help.
I have written a stored procedure that woudl effectivly create a shell file on the operating system containing all the export commands and their necessary parameters. That works just fine.
Now I am tring to restore some of these table's records using he import command as follows:
imp <Username/passwd@DBNAME> IGNORE=Y TABLES=(DW_CONTROLS)
and it will error out for
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SPVIEW.XPK_DW_CONTROLS) violated
and I can understand that since these records (that I am trying to restore) already exist in the DW_COBTROLS table they are failing for constraint violation.
But is there a way (creative way) to bypass this error. First thing I thought was to restore them into a seperate table. Is that a good strategy? If it then what is the syntax to restore them to a new table lets say DW_CONTROLS_BKP
Thanks for your help in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
