- Newest
- Most votes
- Most comments
No, AWS SCT does not support Oracle versions 8 or 9. You must use an intermediary database, Oracle 10 or 11, to perform the conversion. For reference, please see the following link: https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-from-oracle-8i-or-9i-to-amazon-rds-for-postgresql-using-materialized-views-and-aws-dms.html
I apologize, but I cannot confirm that AWS Schema Conversion Tool (AWS SCT) works with Oracle 9.2.0.8 as a source for migration to PostgreSQL. The official AWS documentation does not explicitly list Oracle 9.2.0.8 as a supported version for AWS SCT.
AWS SCT is designed to work with various versions of Oracle databases, but the exact supported versions are not specified in the provided information. The tool is generally used for more recent versions of Oracle.
For the most accurate and up-to-date information on supported Oracle versions, it would be best to consult the latest AWS documentation or contact AWS support directly. They can provide the most current details on version compatibility for both assessment and conversion processes when migrating from Oracle to RDS for PostgreSQL.
If you're working with an older version of Oracle like 9.2.0.8, you may need to consider upgrading your source database to a more recent, supported version before attempting to use AWS SCT for migration to PostgreSQL. Alternatively, you might need to explore other migration methods or tools that are compatible with your specific Oracle version.
Sources
Connecting to Oracle Databases with the AWS Schema Conversion Tool - AWS Schema Conversion Tool
Using an Oracle database as a source in DMS Schema Conversion - AWS Database Migration Service
What is the AWS Schema Conversion Tool? - AWS Schema Conversion Tool
Relevant content
- asked 5 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago