[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
7.4

Oracle 10g: SQL - PL/SQL script needed to recover "deleted" groups in a table

Asked by Tolomir in Oracle 10.x, PL / SQL

Tags: oracle, 10g, deleted, sql

Hello,

I got this table

ID..................NAME......................................................DELETED
8412890........AG-ENV..................................................0
71294............AG-ENV (Delete) 71294.........................1
8412891........AG-EWMV...............................................0
46820............AG-EWMV (Delete) 46820......................1
8412892........AG-GIS...................................................0
61738............AG-GIS (Delete) 61738..........................1

This is a table of groups, that are automatically created by a LDAP synchronization.

Now in case of a LDAP error, it could happen that all groups are deleted.
So on the next synchronization, these deleted groups, that always exists in the LDAP tree, are recreated and I get entries like shown above.
(A group with the same name but new ID is created, but since file permissions were granted for the old ID, this is quite useless for me)

I'm looking for a sql statement, that:

identifies all group names that were deleted and for which a new group was created like this

ID..................NAME......................................................DELETED
8412892........AG-GIS...................................................0
61738............AG-GIS (Delete) 61738..........................1

Then deletes the group with number "8412892" and modifies "61738" back to

61738............AG-GIS...................................................0

This should be repeated for all such pairs.

On the next synchronization, the remaining "old" group will be re-recognized and handled as if the former deletion did not happen at all.

I would execute that script in an emergency recovery case.

Regarding performance, there are about 800 groups I have to deal with so a (PL/SQL) script would be really useful!

Thank you,
Tolomir
[+][-]08/16/07 08:00 AM, ID: 19708804Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08/17/07 04:30 AM, ID: 19715893Accepted Solution

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

About this solution

Zones: Oracle 10.x, PL / SQL
Tags: oracle, 10g, deleted, sql
Sign Up Now!
Solution Provided By: lumolnar
Participating Experts: 1
Solution Grade: A
 
[+][-]08/17/07 05:13 AM, ID: 19716077Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08/29/07 04:48 AM, ID: 19790256Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09/06/07 07:28 AM, ID: 19840328Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091021-EE-VQP-81 / EE_QW_1_20070628