Error "ORA-00955: name is already used by an existing object" in Batch Run after generating Vi (4308809)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error "ORA-00955: name is already used by an existing object" in Batch Run after generating Vi
Description

After performing index generation of virtual indexes, I click the Batch Run button to execute and run all the alternatives. The problem is that some of the scenarios fail with the following error:

ORA-00955: name is already used by an existing object
These failed scenarios contain multiple indexes, where one of these indexes was already created in a previous scenario. I thought these indexes would be dropped after each scenario was executed.
Cause

Drop Index Table command applied to incorrect schema when current schema is different from login schema
Resolution

WORKAROUND
none
STATUS
Issue fixed in version 8.0. The latest version of SQL Optimizer for Oracle can be downloaded at:

https://support.quest.com/Search/SearchDownloads.aspx
Defect ID

ST72578

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title