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.