Can the tablespace data files for the SCM database be created in a non-default location?

book

Article ID: 106903

calendar_today

Updated On:

Products

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction



Our DBA has a specific folder structure for Oracle data files that is not the default location.  Is there a way to have the SCM HDBSetup utility create the SCM tablespaces in the DBA's preferred folder rather than the default folder location?

Environment

CA Harvest SCM all versions and platforms
Oracle database all versions

Resolution

Yes.  During the "CR" task, HDBSetup will ask for your preferred names for the data files associated with the 3 SCM tablespaces.  You can accept the default names that you find in the square brackets for each file name, or specify your own.  If you want the data files to be saved to an alternate location, you should specify the folder path as well as the file name.

Enter 'Meta' tablespace file path and name [HarvestMeta.ora]: 
/my/new/data/folder/HarvestMeta.ora 

Enter 'Blob' tablespace file path and name [HarvestBlob.ora]: 
/my/new/data/folder/HarvestBlob.ora 

Enter 'Index' tablespace file path and name [HarvestIndex.ora]: 
/my/new/data/folder/HarvestIndex.ora 

Additional Information

If HDBSetup finds that the tablespaces have already been created, it will use the data files for your tablespaces in their current location.  Anything you specify as far as a new name or location for the data files will be ignored.