It's all about the answers!

Ask a question

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


Michael Bunnell (6821819) | asked Dec 18 '12, 12:59 p.m.
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

2 answers



permanent link
Grazielle Codogno (15316) | answered Nov 06 '14, 6:50 a.m.
edited Nov 06 '14, 6:53 a.m.
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.






permanent link
Grazielle Codogno (15316) | answered Nov 06 '14, 7:01 a.m.
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.

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.