Home icon

Enable Amazon RDS for Oracle immutable tables for protected workloads

Database Blog

This article covers how to enable and use immutable tables on Amazon RDS for Oracle for protected workloads where data cannot be modified after it is written.

Specifically, the article covers:

  • Overview of immutable tables in Oracle, which are insert-only and prevent unauthorized modifications or deletions
  • Prerequisites to enable immutable tables on Amazon RDS for Oracle, including setting the compatible parameter
  • Steps to create an immutable table with data retention periods specified
  • Using AWS Backup Vault Lock to provide immutability for RDS backups
  • Cleanup steps to delete data from and drop immutable tables
  • Conclusion on the benefits of using immutable tables on RDS for Oracle
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Sep 5
2024
Amazon RDS for Oracle now supports OEM and OLS options with Multitenant configuration
Sep 11
2024
Migrate an Oracle database to Amazon RDS for Oracle using Oracle GoldenGate Microservices Architecture
Aug 29
2024
Migrate Amazon RDS for Oracle BLOB column data to Amazon S3
Aug 5
2024
Amazon RDS for Oracle now supports July 2024 Release Update

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.