We are working on a large-scale OAC governance initiative involving ~4,500 datasets spread across personal folders. Our goal is to programmatically move all datasets to shared folders as part of DR migration prep. We have hit blockers on both dataset storage layers.
Background — Two dataset storage locations in OAC:
- Datasets root (
/@default/{datasets}) — datasets created before January 2026 release - Catalog root (
/@Catalog/users/) — datasets created After January 2026 release
Blocker 1 — Datasets root (/@default/): No API path exists
The official catalog move API (POST /api/20210901/catalog/folders/{id}/actions/move) returns 404 "Catalog object missing" for any dataset under /@default/. These datasets are invisible to the catalog API entirely. There is no known supported REST API to move them programmatically. With thousands of datasets this cannot be done manually via UI.
Blocker 2 — Catalog root (/@Catalog/): API works but only with OAC Profile token
For datasets under /@Catalog/users/, the move API does work — but only when using an OAC Profile Access Token (manually downloaded from OAC UI → Profile → Access Tokens). When using an IDCS OAuth token (same user, same permissions, ROPC grant type), the API returns 500 Internal Server Error. Authentication passes (no 401/403) but the operation fails. This blocks any automation via scheduled jobs since Profile tokens require a human to download them.
Additionally, the Profile token can only move datasets the token owner has access to. Datasets owned by other users require ownership transfer first — and there is no supported bulk API for that either. With ~4,500 datasets across hundreds of user accounts, this makes a fully automated solution impractical with current API capabilities.
Questions for the community:
- Has anyone found a supported API to move datasets under the
/@default/ path? - For
/@Catalog/ datasets — is there a token type or grant type that works for write operations without manual token download? - Is Oracle planning to add full dataset move support across both storage layers?
We have an open Oracle SR (#4-0003286966). Would love to hear if others have found a way forward.
Thanks & Regards,
Pavan
