关于DBA_TABLES中SECONDARY列的含义

关于DBA_TABLES中SECONDARY列的含义

在Export Utility (exp or expdp) does not Export DR${name} Secondary Tables of Text Indexes (文档 ID 139388.1)文章中，有如下的说明：

The column 'SECONDARY' of DBA_TABLES indicates if the table is a secondary object created by the ODCIIndexCreate method of the Oracle's Extensibility Framework (Y or N).

而在最新的11gR2的文档中（http://docs.oracle.com/cd/E11882_01/server.112/e40402/statviews_2117.htm#REFRN20286），有如下的说明：
Indicates whether the table is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N)

 

如下是Export Utility (exp or expdp) does not Export DR${name} Secondary Tables of Text Indexes (文档 ID 139388.1)的全文：

Problem Description
===================

You perform a full export and notice that not all tables are exported.
The missing tables are  all named DR$index_name$? tables.
When you try to perform a table export of such tables an error is returned:

    EXP-00011: DR$index_name$I does not exist
    EXP-00011: DR$index_name$K does not exist
    EXP-00011: DR$index_name$N does not exist
    EXP-00011: DR$index_name$R does not exist

In DBA_TABLES you see that these tables have the value 'Y' in the column SECONDARY.

Solution Description
====================

This is intended behavior.
Secondary objects are not exported because the CREATE INDEX at import time will recreate them.

The column 'SECONDARY' of DBA_TABLES indicates if the table is a secondary object
created by the ODCIIndexCreate method of the Oracle's Extensibility Framework (Y or N).

References
==========

Note:104262.1 DML Processing in Oracle Text

Additional Search Words
=======================

Oracle Text internal index Tables