# FAQ **Q: Is it possible to migrate Oracle Database Enterprise Edition running on premises to Oracle Database Standard Edition 2 on Amazon RDS for Oracle or on Amazon EC2?** **A:** Yes. You must analyze the Enterprise Edition features that you're using, such as Transparent Data Encryption (TDE) or Advanced Compression, and determine whether you need those features on the target Oracle database. For information about other features, see the AWS Prescriptive Guidance guide [Evaluate downgrading Oracle databases to Standard Edition 2 on AWS](https://docs.aws.amazon.com/prescriptive-guidance/latest/evaluate-downgrading-oracle-edition/welcome.html). **Q: Can we use a mixed approach such as AWS DMS and Oracle Data Pump together to migrate existing data?** **A:** Yes. We recommend that you use AWS DMS for large object (LOB) column migration and Oracle Data Pump for non-LOB column tables. **Q: Can we use AWS DMS and Oracle Data Pump together for near zero downtime migration?** **A:** Yes, you can use Oracle Data Pump to migrate an existing database, and then use AWS DMS to replicate only ongoing changes, starting from a specific system change number (SCN) that was recorded before using Oracle Data Pump. **Q: How can we use Oracle GoldenGate to enable active-active database replication and disaster recovery?** **A:** Use an additional GoldenGate hub, either on premises or on the EC2 instance. The GoldenGate hub moves transaction information from the source database to the target database. **Q: How can we determine whether Amazon RDS for Oracle will be suitable as the target database?** **A:** Make sure that all required features are supported on the target Amazon RDS for Oracle database. For more information, see [RDS for Oracle features](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Concepts.FeatureSupport.html) in the Amazon RDS documentation. **Q: How can I get common DBA operations such as the alter command to work in the target Amazon RDS for Oracle database?** **A:** To administer the database, see the [list of commands that work differently](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.html) in Amazon RDS for Oracle. **Q: Can I use Oracle Data Guard to migrate ongoing replication changes to Amazon RDS for Oracle.** **A:** No. You can use Oracle Data Guard only for Oracle on Amazon EC2 or Amazon RDS Custom for Oracle targets. **Q: Will AWS help me align the deployment of the AWS service with my existing Oracle agreements?** **A:** No. An [AWS Partner](https://aws.amazon.com/partners/work-with-partners/) can help you address Oracle to AWS license deployment questions. For more information, see the AWS blog post [Understanding Your Options for Deploying and Licensing Oracle on AWS](https://aws.amazon.com/blogs/apn/understanding-your-options-for-deploying-and-licensing-oracle-on-aws/). **Q: What will happen to my target Amazon RDS for Oracle instance if Oracle ends Extended Support for the database version? (For example, [Oracle Database version 19c Extended Support](https://support.oracle.com/knowledge/Oracle%20Database%20Products/742060_1.html) ends on December 31, 2032.)** **A:** Using the same example, starting on January 1, 2033, all instances that are running on Oracle Database version 19c will be automatically upgraded to 21c. Also, you won't be able to create Amazon RDS for Oracle instances with Oracle Database version 19c. **Q: Can I use Oracle Exadata features such as SmartScan in Amazon RDS for Oracle?** **A:** Amazon RDS for Oracle doesn't support the SmartScan feature. In your on-premises database, you need to identify the queries that use SmartScan and convert them to use database indexes instead. **Q: How can I analyze my workload to determine the IOPs, throughput, CPU, and memory that is actively being used by the source Oracle database?** **A:** Generate an [Automatic Workload Repository (AWR)](https://www.oracle.com/technetwork/database/manageability/diag-pack-ow09-133950.pdf) report from your source database or run a [Database Current State Investigation (CSI)](https://dbcsi.d29q8g3b9hzyur.amplifyapp.com/) script to get this information.