It's all about the answers!

Ask a question

Jazz Data Warehouse on Oracle Exadata

Luca Martinucci (1.0k396112) | asked Jan 14 '14, 3:18 p.m.
edited Jan 14 '14, 3:19 p.m.
We have Oracle installed on an Exadata machine.
We use it as the back-end database for JTS, CCM and QM applications (versions 4.0.5)
The problem arises when we try to configure the Data Warehouse: the setup wizard asks to provide a folder on the db server filesystem to contain the DW table spaces that the wizard will create.
Unluckily, it seems that Exadata has not a real filesystem associated....
Any workarounds?

Accepted answer

permanent link
Rafik Jaouani (5.0k16) | answered Jan 14 '14, 4:19 p.m.

Please read the following doc. You will find instructions on how to generate the data warehouse DDL and Upgrade scripts. Once generated, you can edit the setup scripts and change how the table spaces get created (though you need to use the same names).

After creating the data warehouse manually using the generated scripts, you may still have to specify a folder for the data files. But that folder will not be used.


Luca Martinucci selected this answer as the correct answer

One other answer

permanent link
Vidya Malkarnekar (1.0k15) | answered Jan 14 '14, 4:13 p.m.
Hi Luca, 
I am not much familiar with Oracle Exadata, but if creating Oracle tablespaces in advance is possible, then maybe you should look into the article -- It has a section called 'Modifying the Tablespace creation step".

Luca Martinucci commented Mar 06 '14, 3:59 a.m.

The instructions provided in the article worked.

We were able to manually create the DWH database and then to run the setup wizard without being compelled to specify a tablespaces folder.

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.