By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Using Oracle Text Indexes - AWS RDS for Oracle

0

We have Oracle text searches in use in our on-prem databases, and trying to use the same in RDS. I cannot seem to find documentation as to how text indexes may be configured in RDS. Can someone point me in the right direction?

Thanks,

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceOracle
Language
English
rePost-User-4138389
asked a year ago435 views
1 Answer
1
Accepted Answer

Hello,

Oracle Text (File and URL data store types are not supported) [1] is a supported feature in RDS for Oracle and you should be able to create text indexes as in any Oracle database.

For documentation, you can refer to Oracle docs [2] on this. Let me know if I answered your question or if you have any follow-up.

Thanks, Ranjini Menon

References :

[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Concepts.FeatureSupport.html

[2] https://docs.oracle.com/en/database/oracle/oracle-database/19/ccapp/indexing-with-oracle-text.html#GUID-F6B60A4A-B256-415A-9C54-C67C612BFA9B

profile pictureAWS
RanjiniMenon-AWS
answered a year ago
  • sniper57
    4 months ago

    In Reference 1, I don't see any mention of Oracle Text. Please can you confirm where it is mentioned? Also how do I enable it in Oracle RDS? It doesn't appear as an Option? Thank you

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content