Oracle Workflow Guide
Release 2.6.2
Part Number A95265-02 |
|
 |
 |
|
 |
 |
 |
| |
Previous |
Next |
|
Contents |
Index |
Glossary |
Wfdirchk.sql
Use wfdirchk.sql to check for the following conditions in your directory service data model:
- Invalid internal names that contain the characters '#', ':', or '/' in WF_USERS.
- Invalid compound names in WF_USERS or WF_ROLES.
- Duplicate names in WF_USERS or WF_ROLES.
- Multiple names in WF_USERS or WF_ROLES linked to the same row in the original repository.
- Missing display names in WF_USERS or WF_ROLES.
- Invalid Notification Preference or null e-mail address if the Notification Preference is MAILTEXT, MAILHTML, or SUMMARY in WF_USERS or WF_ROLES.
- Invalid Status in WF_USERS.
- Rows in WF_USERS that do not have a corresponding row in WF_ROLES.
- Invalid internal names in WF_ROLES that contain the characters '#' or '/' or have a length greater than 30 characters.
- Invalid user/role foreign key in WF_USER_ROLES.
- Missing user/role in WF_USER_ROLES (every user must participate in its own role).
- Duplicate rows in WF_USER_ROLES.
Wfdirchk.sql should return no rows to ensure that your directory service data model is correct.
Use the script as follows:
sqlplus <user/pwd> @wfdirchk
Copyright © 2002 Oracle Corporation.
All Rights Reserved.