Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How is the DR Table Name Format chosen?

Amin AdatiaMar 19 2019

Oracle 18.5

Oracle Text

Migrated from 11.2.0.3 with existing Oracle Text Indexes on Partitioned Tables. The DR Tables come across with the format DR#. New Text Indexes get the DR Table format as DR$. What determines when a new partition is created which format style to use? We have routines which count the Tokens for the DR$I tables prior and post Optimize. How do I know which format is being used?

Regards

Comments
Post Details
Added on Mar 19 2019
0 comments
658 views