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

3 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.