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
How to view 'Bin....' constraints?
Re: How to view 'Bin....' constraints?
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:
Then, you need to restore initial indexes names in the following way:
For instance:
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.
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';
Code: Select all
ALTER INDEX "BIN$INDEX_NAME" RENAME "ORIGINAL_INDEX_NAME";
Code: Select all
ALTER INDEX "BIN$DBo9UChtZSbgQFeMiAdCcQ==$0" RENAME "AX_INDEX1";
http://docs.oracle.com/cd/B28359_01/ser ... ADMIN01511
Best Regards.