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
Friday, August 6, 2010
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.
Subscribe to:
Posts (Atom)