Skip Headers
Oracle Workflow Administrator's Guide
Release 2.6.3.5
Part Number B12160-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 set in WF_USERS or WF_ROLES to receive e-mail.
- 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 © 2003, 2004, Oracle. All rights reserved.