If you use non-standard table space names in your Oracle AE DB, CA has put together instructions for how to modify the SQL the AE uses to create new DB objects for new CPs.
KB000126471 – JCP/CP table creation assumes default tablespace names
The SQL statement mentioned in that KB article is stored in the initial data file utilities/db/general/12.2/uc_ini.txt:
3594 F001CCREATE_MQCP
3595 F002CORACLE
3596 F003CCREATE TABLE &NEW_MQ#( MQCP_PK NUMBER(38,0) NOT NULL, MQCP_System VARCHAR2 (8 CHAR) NULL, MQCP_CAddr VARCHAR2 (32 CHAR) NULL, MQCP_CSRName VARCHAR2 (8 CHAR) NULL, MQCP_CAcv NUMBER(38,0) NULL, MQCP_BAddr VARCHAR2 (32 CHAR) NULL, MQCP_BSRName VARCHAR2 (8 CHAR) NULL, MQCP_BAcv NUMBER (38,0) NULL, MQCP_FAddr VARCHAR2 (32 CHAR) NULL, MQCP_LogAddr VARCHAR2 (32 CHAR) NULL, MQCP_PhysAddr VARCHAR2 (32 CHAR) NULL, MQCP_BTable VARCHAR2 (8 CHAR) NULL, MQCP_SchedTime DATE NULL, MQCP_Status NUMBER(38,0) NULL, MQCP_Priority NUMBER(38,0) NULL, MQCP_DRole VARCHAR2 (32 CHAR) NULL , MQCP_LAddr VARCHAR2 (32 CHAR) NULL, MQCP_Len NUMBER(38,0) NULL, MQCP_Msg BLOB NULL, CONSTRAINT PK_&NEW_MQ# PRIMARY KEY ( MQCP_PK ) using index TABLESPACE UC4_INDEX) LOB(MQCP_Msg) STORE AS(ENABLE STORAGE IN ROW CACHE) TABLESPACE UC4_DATA ENABLE ROW MOVEMENT NOCOMPRESS ; CREATE SEQUENCE SQ_&NEW_MQ# INCREMENT BY 1 START WITH 1 MAXVALUE 2147483647MINVALUE 1 CYCLE CACHE 1000 NOORDER ;CREATE INDEX NK_&NEW_MQ#_BAcv ON &NEW_MQ#(MQCP_BAcv) TABLESPACE UC4_INDEX ;CREATE INDEX NK_&NEW_MQ#_Prio ON &NEW_MQ#(MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status) TABLESPACE UC4_INDEX ;CREATE INDEX NK_&NEW_MQ#_SchTime ON &NEW_MQ#(MQCP_SchedTime) TABLESPACE UC4_INDEX ;
3597 R
This is the only place in the uc_ini.txt file where the table space names are mentioned. We’re already updating table space names in all initial data .sql files. If we also change the table space names in the uc_ini.txt file prior to the DB load, then we won’t need to change the value later in the DB. We’ll consider this approach because it will make upgrades easier.