Fix index limit exceed error
@@ -191,13 +191,21 @@ CREATE TABLE IDN_OAUTH2_RESOURCE_SCOPE (
PRIMARY KEY (RESOURCE_PATH),
FOREIGN KEY (SCOPE_ID) REFERENCES IDN_OAUTH2_SCOPE (SCOPE_ID) ON DELETE CASCADE)
/
+
+CREATE BUFFERPOOL BP32K IMMEDIATE SIZE 250 AUTOMATIC PAGESIZE 32K
+/
+
+CREATE LARGE TABLESPACE TS32K PAGESIZE 32K MANAGED by AUTOMATIC
+STORAGE BUFFERPOOL BP32K
+/
+
CREATE TABLE IDN_SCIM_GROUP (
ID INTEGER NOT NULL,
TENANT_ID INTEGER NOT NULL,
ROLE_NAME VARCHAR(255) NOT NULL,
ATTR_NAME VARCHAR(1024) NOT NULL,
ATTR_VALUE VARCHAR(1024),
- PRIMARY KEY (ID))
+ PRIMARY KEY (ID)) IN TS32K
/
CREATE INDEX IDX_IDN_SCIM_GROUP_TI_RN ON IDN_SCIM_GROUP (TENANT_ID, ROLE_NAME)
