AWS DMS - Data from Oracle EBS database - from View

0

AWS DMS only pulls Table from Database (In my case Oracle EBS Database) is there any possibility to pull View data from Database using AWS DMS.

已提问 2 年前246 查看次数
1 回答
0

You can pull data once from a view using attribute exposeViews=true on DMS. You can't use it for ongoing replication. Please see details : https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html [Extra connection attributes when using Oracle as a source for AWS DMS] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Troubleshooting.html [Troubleshooting issues with Oracle] - [Pulling data from views]

AWS
已回答 2 年前
  • exposeViews=true, this attribute is only required, if it has mix of tables and views. If your full load only has views, this attribute is not required.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则