Question
ING Bank NV
NL
Last activity: 5 Apr 2024 8:16 EDT
tables created default webuser node
Hi Pega,
we are using split schema design in our pega running on oracle database.
we have base user and admin user as separate accounts to connect the application to database.
in our webuser(base user) - we see lot of tables created such as PAD_365_20_OBJECTDATA,PAD_365_26_OBJECTDATA etc,. and these tables have LONG Column in them.
we are trying to have seperate tablespace for each user and as part of this we were moving all the tables by redefinition(online) move to the dedicated tablespace.
But oracle doesnt support online move for tables that have LONG rows, and it needs downtime for performing expdp/impdp on these webuser connections.
Could you please help us with the purpose of the below tables.
is it harm in truncating these tables while the pega is running fine ?
Accepted Solution
Updated: 5 Apr 2024 8:16 EDT
Pegasystems Inc.
CA
Please check with your application team if they're creating these tables from the application.
As @MarijeSchillern mentioned, these are not Pega-related tables.
Updated: 3 Apr 2024 12:42 EDT
Pegasystems Inc.
GB
@TejaswiT4511 I don't recognize the names - this seems to be an Oracle DBA question.....
in a split schema installation with Oracle, you can have separate tablespaces for each user. The users of the rules schema and the data schema can share the same tablespace in your Oracle database. If you create separate tablespaces, base the size of the data schema user tablespace on the estimated number of work objects in the application. You can use the Tablespace Creation Wizard, part of the Oracle Enterprise Manager, to configure the tablespace. However, moving all the tables to the dedicated tablespace while the system is online would require careful planning and execution to avoid any disruption to the running application.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Configure an Oracle database for a VM-based installation > Creating database
Configure an Oracle database for an installation > Configure required run-time
@TejaswiT4511 I don't recognize the names - this seems to be an Oracle DBA question.....
in a split schema installation with Oracle, you can have separate tablespaces for each user. The users of the rules schema and the data schema can share the same tablespace in your Oracle database. If you create separate tablespaces, base the size of the data schema user tablespace on the estimated number of work objects in the application. You can use the Tablespace Creation Wizard, part of the Oracle Enterprise Manager, to configure the tablespace. However, moving all the tables to the dedicated tablespace while the system is online would require careful planning and execution to avoid any disruption to the running application.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
Configure an Oracle database for a VM-based installation > Creating database
Configure an Oracle database for an installation > Configure required run-time
Please consult the Installation Guides and documentation on our Documentation server eg Planning tablespace
Accepted Solution
Updated: 5 Apr 2024 8:16 EDT
Pegasystems Inc.
CA
Please check with your application team if they're creating these tables from the application.
As @MarijeSchillern mentioned, these are not Pega-related tables.