ORA-00955 when deploying a table [message #475052] |
Sat, 11 September 2010 13:28 |
hristo
Messages: 258 Registered: May 2007
|
Senior Member |
|
|
Hi!
Did an upgrade of OWB from 10.2 to 11.2.
How do I deploy my tables? If I only right click and choose deploy I get:
ORA-00955:name is already used by an existing object
I dont want to drop the object as it contains data(rows). Which option do I choose?
Regards
H
|
|
|
Re: ORA-00955 when deploying a table [message #475063 is a reply to message #475052] |
Sun, 12 September 2010 03:12 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
[I don't use Warehouse Builder so this might not help at all]
Is renaming one of objects an option?
If both objects are "tables", are they, actually, the same table? If so, do you really need to deploy a new one? Can't you use the old one?
If a new table is completely different from the old one, then I guess you *should* rename one of them.
|
|
|