nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Bulk deleting Unused datasets/datasources with admin privileges

Shubham Mishra-Oracle

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

ORACLE (BMCDW)

Description (Required):

We have noticed using ( Data Governance Plugin) that there are total 1000+ unused Datasets. We are planing to delete/remove these unused datasets. (Using Service Account)

Manually deleting these many datasets will not be feasible and efficient. Currently, we do not have a way using which we can delete these unused datasets at once. Can we have a way to bulk delete the datasets using service account with admin privileges.

Use Case and Business Need (Required):

We are not able to bulk delete the unused datasets in Horizon OAC. Manually deleting these many datasets one by one will not be feasible and efficient

Enhancement Request / Service Request: Enhancement Request

Related SR -> SR 3-29420592771

Find more posts tagged with

Data Modelling and Datasets

Developers

Needs Votes

Status: Needs Votes

Comments

Michal Zima

I think, this is another "use-case", which should be part of of long promised API for DV (which is, unfortunatelly still not available)- this API should allow you:

1) To identify data sets not used/referenced in any other "objects" (workbooks, data flows, analyses etc...)

2) To delete those identified data sets

Adam Bloom-Oracle

Please take a look at this Content functionality under the Console:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/manage-content.html

Shubham Mishra-Oracle

@Adam Bloom-Oracle

Thanks for sharing the doc, We use this feature when any user is no more with Oracle, then we transfer the ownership. We cannot own every thing and manually owning and deleting these many datasets will not be feasible and efficient.