Home » Developer & Programmer » Data Integration » ORA-00955 when deploying a table (rdbms 11.2, OWB repos >, SLES11 x64)
ORA-00955 when deploying a table [message #475052] Sat, 11 September 2010 13:28 Go to next message
Messages: 258
Registered: May 2007
Senior Member

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?

Re: ORA-00955 when deploying a table [message #475063 is a reply to message #475052] Sun, 12 September 2010 03:12 Go to previous message
Messages: 21687
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.
Previous Topic: Regarding default select clauses executing during OWB Mapping execution -
Next Topic: Use OWB towards source db
Goto Forum:

Current Time: Sat Sep 18 05:51:34 CDT 2021