How to create Table Space manually for CA Strong Authentication
Article ID: 36130
Updated On:
Products
Issue/Introduction
We are running Arcot common script for create Arcot db. The DB user has no grant to create new table space, so we have to ask our DBA to create tablespace. Which is the required portion of the arcot-db-config-for-common-8.1.sql that we need to send to the DBA to run separately?
Environment
Product: CA Advanced Authentication 8.1 (Strong Authentication and Risk Authentication)
DB: Oracle (All supported versions, Refer Release notes)
Resolution
If the user does not have the required permissions, a DBA can manually create the reports tablespace and delete the section in this DB script that creates this tablespace. The parameters for creating the reports tablespace in the arcot-db-config-for-common-8.1.sql database script can be changed according to the DBA's preferences. However, ensure that the tablespace name is ARReports.
Below is the section that is used in common scripts to delete existing table space(if available) and recreate it. Please refer to arcot-db-config-for-common-8.1.sql script for Oracle. You need to run this query snippet separately.
----------------------------------------------
DECLARE
filename varchar2(50) := 'tabspace_arreports_'|| to_char(current_timestamp, 'YYYY-MM-DD-HH24-MI-SS') || '.dat';
cursor c1 is select tablespace_name from user_tablespaces where tablespace_name = 'ARREPORTS';
BEGIN
FOR I IN c1 LOOP
execute immediate 'DROP TABLESPACE '||I.tablespace_name||' including contents and datafiles';
END LOOP;
EXECUTE IMMEDIATE 'CREATE TABLESPACE ARREPORTS DATAFILE '''||filename||''' SIZE 20M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED DEFAULT STORAGE (INITIAL 10K NEXT 50K MINEXTENTS 1 MAXEXTENTS 999) ONLINE';
END;
/
---------------------------------------------
Additional Information
Detailed information of this process can be found in below CA wiki page
How to Configure the Database Server for Strong Authentication
Section: Configuring Oracle Database
Feedback
