1 Answer
- Newest
- Most votes
- Most comments
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]
answered 2 years ago
Relevant content
- asked 10 months ago
- Accepted Answerasked 9 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated 21 days ago
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.