Devart Forums

Posted: **Wed 28 Jan 2015 17:24**

Hi Folks:

A few months ago we had an issue with dozens of tables being deleted. I retrieved them from the recycle bin in Oracle.

The data restored ok, but the table constraints (all the Primary keys, etc.) all came back with names like: BIN$AUMfy9tKw+TgUAB/AQAibw==$0

Now I can view those in another Oracle IDE that I use, but in dbForge they do not show (and that affects schema syncs and stuff too).

I'd like to be able to change their names from within dbForge. Is there a setting I'm missing that would make them show up?

On a side note, with the new update (3.7) I can now edit all the sys..... constraint and key names within dbForge which is a big help.

Matthew

Posted: **Thu 29 Jan 2015 15:06**

Hello,

Thanks for the post!

dbForge Studio for Oracle does not display indexes and constraints that start with "BIN$" in Database Explorer. So far, we do not plan to implement this functionality in the nearest future.

As a workaround, please do the following:

Execute the given query to get all table indexes:

Code: Select all

SELECT INDEX_NAME FROM USER_INDEXES WHERE TABLE_NAME = 'YOUR_TABLE_NAME';

Then, you need to restore initial indexes names in the following way:

Code: Select all

ALTER INDEX "BIN$INDEX_NAME" RENAME "ORIGINAL_INDEX_NAME";

For instance:

Code: Select all

ALTER INDEX "BIN$DBo9UChtZSbgQFeMiAdCcQ==$0" RENAME "AX_INDEX1";

Also, to get an additional information, read the Restoring Tables from the Recycle Bin article:
http://docs.oracle.com/cd/B28359_01/ser ... ADMIN01511

Best Regards.

Devart Forums

How to view 'Bin....' constraints?

How to view 'Bin....' constraints?

Re: How to view 'Bin....' constraints?