Subscribe

OCI DWH 7.3 How to create a custom view/table

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