We're trying to solve is that we've been given an oracle Tablespace for the AA database. But the reporting functionality wants a separate Tablespace for the reporting table. What configuration files house the settings to tell the system where the reporting database is at so that we can set up reporting?

Release : 9.1

Component : AuthMinder(Arcot WebFort)

Product also had capability to use the Default Table space but that is not generally used by customers now a days, if you want to test here are the steps to do that -

Reports should work without requiring Tablespace creation privilege.
    Description:
 Arcot common database scripts need the privilege to create Tablespace for generating reports. If this privilege is not available, 
 the default tablespace can be used based on a configuration setting.
 
    Resolution:
    A (hidden) configuration knob can be specified in arcot/report/config section of adminserver.ini file to use default tablespace. 
    
    If 'create tablespace' privilege is not available for reports, follow the steps below:
    1. Make a section with following entries in adminserver.ini file (available at ARCOT_HOME/conf) at the end
    
     [arcot/report/config]
     UseDefaultTableSpace=true
     
    2. Restart the application server.
    
    Note: If the knob is true, it will use the default table space.