Home » Developer & Programmer » Data Integration » ORA-00955 when deploying a table (rdbms 11.2, OWB repos 10.2.0.3 > 11.2.0.1, SLES11 x64)
ORA-00955 when deploying a table [message #475052] Sat, 11 September 2010 13:28 Go to next message
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 Go to previous message
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.
Previous Topic: Regarding default select clauses executing during OWB Mapping execution -
Next Topic: Use 11.2.0.1 OWB towards 10.2.0.3 source db
Goto Forum:
  


Current Time: Thu Dec 26 19:26:23 CST 2024