Migrating Real-Time Indexing Data Using ADS Definition

Oracle delivers an ADS definition to copy or migrate real-time indexing metadata from one environment to another.

For information on using ADS, see Understanding ADS Projects.

ADS Definition for Real-Time Indexing

ADS definition for real-time indexing —PTSF_REALTIMEINDEXING.

PTSF_INDEX_GROUP

Group

Details

Group Name

Group for PTSF_INDEX

Group Description

Merge group for Search Index RTI metada

Group Member

  • PTSF_INDEX.PTSF_ATTACHMENT

  • PTSF_INDEX.PTSF_RTI

Group Properties

Merge configurations

Tables for PTSF_REALTIMEINDEXING

Table

Description

PTSF_INDEX

Stores search definition details, such as connected query, query, application class, and so on.

PTSF_INDEXATT

Stores attachment information.

PTSF_INDEXATT_S

Stores SQL for attachments.

PTSF_INDEXCQRY

Stores parent child mapping information.

PTSF_INDEXDSEC

Stores document security.

PTSF_INDEXQRY

Stores queries in the index.

PTSF_INDEXRCFLD

Stores attribute information.

PTSF_RELLANGQRY

Stores related language information.

PTSF_INDEXTRREC

Stores trigger records for real-time indexing.

PTSF_INDEXTRFLD

Stores trigger non-key fields for real-time indexing.

PTSF_INDEX_BODY

Stores summary information.

PTSF_INDEX_DQ

Stores delete query information.

PTSF_INDEX_LUD

Stores last updated datetime details.

PTSF_INDEX_URL

Stores drilling URL information.