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
4 comments:
How to use the “My money” slot machine, with the bonus
How to use the 상주 출장샵 “My 인천광역 출장샵 money” slot 밀양 출장마사지 machine, with 서귀포 출장샵 the bonus 의왕 출장안마 code: $1000.
Post a Comment