OCI DWH 7.3 How to create a custom view/table

INGO_REPINZ — Wed, 04 Jun 2025 14:45:23 GMT

Hello,

until verison 7.2.x in the DWH was a database called 'test', that I could use to create custom tables and views.

Since 7.3 this database is gone, but the dwh_custom-database was introduced.

But there I can not create a view or table. Did some how I could recreate the tables/views I've used to simplify some queries.

I use the default-user, dwhuser.

Any hint would be welcome.

Best Regads

Ingo

Re: OCI DWH 7.3 How to create a custom view/table

ostiguy — Sun, 20 May 2018 17:52:36 GMT

I believe the best practice is to be using the "dwh"user account for any RW activities to dwh_custom. The dwhuser account is purely read only,and thus your inability to use it to create views is expected behavior

Matt

topic OCI DWH 7.3 How to create a custom view/table in Active IQ Unified Manager Discussions

OCI DWH 7.3 How to create a custom view/table

Re: OCI DWH 7.3 How to create a custom view/table