Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

CLM Data Warehouse Oracle - why .ora instead of .dbf files

Hello - while installing CLM 4.0.1, the DBA had 2 specific questions that I could not answer.
  1. Is there a way to customize the data warehouse creation scripts so that the data files can be in one directory and the index files are in another?  The customer uses multiple mount points / directories for the databases and has data files in one directory and index files in another (hope I explained that properly).
  2. Once I ran the create tables step for the data warehouse, the DBA noticed that there were some .ora files that were created.  I saw in the article below where those can be created manually, the locations can be changed but that the names of the files cannot be changed.  I presume that includes changing the extension as well.  Can someone please let me know why it creates .ora files versus .dbf files.  My apologies if the answer is simple but I'm not a DBA or even close to pretending to be one.  The DBA would like to know if it can use .dbf files versus .ora files.

https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup

Thanks so much

Mike

0 votes



2 answers

Permanent link
Hi Michael,

2. .The file extension for Oracle is flexible, so .ora is one that are used while using Oracle databases. If you prefer to use .dbf it won't affect anything. Just please keep the extension up-to-date at any scripts.





0 votes


Permanent link
For the 1. To modify the scripts , you need to create them first by repotools , check this link :https://jazz.net/wiki/bin/view/Main/GenerateDDLScriptsForTheDataWarehouseCreationAndUpgrade.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,507
× 2,357
× 42
× 26

Question asked: Dec 18 '12, 12:59 p.m.

Question was seen: 7,070 times

Last updated: Nov 06 '14, 7:02 a.m.

Confirmation Cancel Confirm