Scope oracle Scan in Purview at Db level

Question

On Purview, when scanning an Oracle source, we can scope it to a respective schema, but we would also like to narrow down the scope to specific tables as well, as it is possible for Azure SQL DB, for instance.

Answer 1

Hello @Anonymous

Thanks for the question and using MS Q&A platform.

When setting up scan, you can choose to scan an entire Oracle server, or scope the scan to a subset of schemas matching the given name(s) or name pattern(s).

Currently, the Oracle service name isn't captured in the metadata or hierarchy.

For more details, refer to Connect to and manage Oracle in Microsoft Purview.

Hope this helps. Do let us know if you any further queries.

---

Please don’t forget to Accept Answer wherever the information provided helps you, this can be beneficial to other community members.