- Newest
- Most votes
- Most comments
Oracle partitioning is a feature that is licensed separately with the Oracle Enterprise Edition licenses. Some advanced partitioning capabilities are not supported in RDS. If the majority of your partitioning is range-based without any problems, you can migrate your database to RDS Oracle EE.
Siebel is one of the applications that benefits from running its database on Amazon RDS (Relational Database Service).
When migrating to RDS, there are a few key considerations:
Licensing: Ensure you have the appropriate Oracle EE licenses for the partitioning functionality you require. RDS provides access to Oracle EE, but some advanced partitioning may need to be licensed separately.
Partitioning Support: Understand the partitioning features supported by RDS Oracle EE. If your current partitioning setup relies on unsupported functionality, you may need to make adjustments during migration.
Migration Process: Plan the database migration to RDS carefully. This may involve database schema changes, data migration, and application updates to work with the new RDS environment.
Performance Optimization: Once on RDS, monitor your Siebel application's performance and make any necessary optimizations to take advantage of the RDS platform's capabilities.
By considering these factors, you can successfully migrate your Siebel database to Amazon RDS Oracle EE and benefit from the managed service and scalability it provides.
Yes, Amazon RDS for Oracle does support partitioning. Oracle Partitioning is a feature that allows you to divide large tables and indexes into smaller, more manageable pieces called partitions. This can improve query performance, facilitate data management operations, and reduce storage costs.
When migrating your Siebel application from an on-premises Oracle database to Amazon RDS for Oracle, you should be able to maintain your existing date range partitioning on critical tables. RDS for Oracle supports various partitioning types, including range partitioning, which is commonly used for date-based partitioning.
It's important to note that while RDS for Oracle supports partitioning, there are some limitations compared to a full on-premises Oracle installation:
-
Some advanced partitioning features may not be available in RDS for Oracle. For example, interval partitioning, partition advisor, and virtual column-based partitioning are not supported.
-
The specific partitioning capabilities may depend on the Oracle Database edition and license you choose for your RDS instance.
-
When migrating, you'll need to ensure that your partitioning strategy is compatible with the RDS environment and that it adheres to any RDS-specific limitations.
Before migrating your Siebel application, it's recommended to thoroughly test your partitioning schemes in an RDS for Oracle test environment. This will help you identify any potential issues or necessary adjustments to your partitioning strategy. Additionally, you may want to consult AWS documentation or reach out to AWS support for specific guidance on migrating your partitioned tables to RDS for Oracle.
Sources
RDS for Oracle features - Amazon Relational Database Service
Homogeneous database migration considerations - AWS Prescriptive Guidance
Oracle table partitioning and PostgreSQL partitions and table inheritance - Oracle to Aurora PostgreSQL Migration Playbook
Relevant content
asked 6 years ago- AWS OFFICIALUpdated 2 years ago
