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

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

Postby mfriend » 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
mfriend
 
Posts: 9
Joined: Thu 30 Oct 2014 15:26

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

Postby .jp » 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/server.111/b28310/tables011.htm#ADMIN01511

Best Regards.
.jp
Devart Team
 
Posts: 303
Joined: Wed 09 Sep 2009 06:55
Location: devart


Return to dbForge for Oracle