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

4 comments:

Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
faethequang said...

How to use the “My money” slot machine, with the bonus
How to use the 상주 출장샵 “My 인천광역 출장샵 money” slot 밀양 출장마사지 machine, with 서귀포 출장샵 the bonus 의왕 출장안마 code: $1000.