Friday, August 6, 2010

Export Failed on DR$ tables

Export fails on objects DR$MYINEDX01$I, DR$MYINEDX01$R, DR$ITK_PM_CERT_DOC_IDX$I,
DR$ITK_PM_CERT_DOC_IDX$R


Those objects are domain indexes dependent tables (CTXSYS), it is not exportable objects and will
be re-created during import as per index re-creation on base table.

SQL> select  u.username,

  2             i.idx_name,
  3          u2.username tab_owner,
  4          o.object_name

  5  from    ctxsys.dr$index i,
  6             dba_users u,
  7          dba_users u2,

  8          dba_objects o
  9  where   u.user_id = i.idx_owner#
 10  and u.username='CUST_INTR'

 11  and i.idx_table# = o.object_id
 12  and o.owner=u2.username

 13  and u2.user_id=IDX_TABLE_OWNER# ;


USERNAME    IDX_NAME               TAB_OWNER       OBJECT_NAME

--------------- ------------------------------ --------------- ------------------------------

CUST_INTR    MYINEDX01               CUST_INTR       ITK_BLOB_TEST

CUST_INTR    ITK_PM_CERT_DOC_IDX           CUST_INTR       ITK_PERFORMANCE_MARK_CERTS


As the objects are already contained in the table list for export, the context indexes MYINEDX01
and ITK_PM_CERT_DOC_IDX will be recreated at import time and will generate the context related
objects: DR$MYINEDX01$I, DR$MYINEDX01$R, DR$ITK_PM_CERT_DOC_IDX$I, DR$ITK_PM_CERT_DOC_IDX$R

Wednesday, August 4, 2010

Responsibilities do not showup for any user.

Hi All,
Let me introduce myself, I am Sharat Manikonda, working for oracle corp. as Applications engineer and have an exp of 5+ in oracle itself.

This is my first post in this Blog and let me start with a small one.

Looking forward to write further

Regards,
Sharat
------------
PROBLEM:

What should we do when Responsibilities does not show up for any user ?

The below scenario will help you to resolve the issue.

Case1: Responsibilities are not showing up after reactivating user accounts by removing the termination end date.

Solution:
---------
1. Make sure that the latest ATG_RUP patch has been applied.
2. Run Concurrent Program System: Administrator Responsibility->Request->'Synchronize WF LOCAL tables'
3. Run Concurrent Program: 'Workflow Directory Services User/Role Validation'.
4. Restart the Workflow Agent Listeners: WF_DEFERRED and WF_JAVA_DEFERRED

The correct way to do this is:

Run Concurrent Program: Workflow Directory Services User/Role Validation twice
fist time with the parameters 10000,Y,N,N
second time with the parameters 10000,N,Y,N

clear browser cache or test in an alternate browser

check for 'Synchronize WF LOCAL tables' request, and remove scheduling this CM request from the requests.