Subversion Repositories DevTools

Rev

Rev 5512 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5512 Rev 5953
Line 1... Line 1...
1 
--------------------------------------------------------
 1 
--------------------------------------------------------
2 
--  File created - Tuesday-October-06-2015
2 
--  File created - Thursday-July-14-2016
3 
--------------------------------------------------------
 3 
--------------------------------------------------------
4 
--------------------------------------------------------
 4 
--------------------------------------------------------
5 
--  DDL for Type ACCMGR_NUMBER_TAB_T
 5 
--  DDL for Type ACCMGR_NUMBER_TAB_T
6 
--------------------------------------------------------
 6 
--------------------------------------------------------
7 
 
 7 
 
Line 20... Line 20...
20 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_DT_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 261 CACHE 20 ORDER  NOCYCLE ;
 20 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_DT_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 261 CACHE 20 ORDER  NOCYCLE ;
21 
--------------------------------------------------------
 21 
--------------------------------------------------------
22 
--  DDL for Sequence SEQ_OBJ_ID
 22 
--  DDL for Sequence SEQ_OBJ_ID
23 
--------------------------------------------------------
 23 
--------------------------------------------------------
24 
 
 24 
 
25 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_OBJ_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1401 CACHE 20 ORDER  NOCYCLE ;
 25 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_OBJ_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1441 CACHE 20 ORDER  NOCYCLE ;
26 
--------------------------------------------------------
 26 
--------------------------------------------------------
27 
--  DDL for Sequence SEQ_ROLE_ID
 27 
--  DDL for Sequence SEQ_ROLE_ID
28 
--------------------------------------------------------
 28 
--------------------------------------------------------
29 
 
 29 
 
30 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_ROLE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1621 CACHE 20 ORDER  NOCYCLE ;
 30 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_ROLE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1681 CACHE 20 ORDER  NOCYCLE ;
31 
--------------------------------------------------------
 31 
--------------------------------------------------------
32 
--  DDL for Sequence SEQ_USER_ID
 32 
--  DDL for Sequence SEQ_USER_ID
33 
--------------------------------------------------------
 33 
--------------------------------------------------------
34 
 
 34 
 
35 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_USER_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 12862 CACHE 20 ORDER  NOCYCLE ;
 35 
   CREATE SEQUENCE  "ACCESS_MANAGER"."SEQ_USER_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 13362 CACHE 20 ORDER  NOCYCLE ;
36 
--------------------------------------------------------
 36 
--------------------------------------------------------
37 
--  DDL for Table APPLICATIONS
 37 
--  DDL for Table APPLICATIONS
38 
--------------------------------------------------------
 38 
--------------------------------------------------------
39 
 
 39 
 
40 
  CREATE TABLE "ACCESS_MANAGER"."APPLICATIONS"
40 
  CREATE TABLE "ACCESS_MANAGER"."APPLICATIONS"
Line 108... Line 108...
108 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
 108 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
109 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 109 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
110 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 110 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
111 
  TABLESPACE "RELEASEM_DATA" ;
 111 
  TABLESPACE "RELEASEM_DATA" ;
112 
--------------------------------------------------------
 112 
--------------------------------------------------------
113 
--  DDL for Table DEF_ACTION_BUTTONS
 - 
 
114 
--------------------------------------------------------
 - 
 
115 
 
 - 
 
116 
  CREATE TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS"
- 
 
117 
   (	"ABTN_ID" NUMBER,
- 
 
118 
	"ABTN_NAME" VARCHAR2(1000 BYTE),
- 
 
119 
	"TEXT" VARCHAR2(50 BYTE),
- 
 
120 
	"ACTION_LINK" VARCHAR2(4000 BYTE),
- 
 
121 
	"EVENT_HANDLER" VARCHAR2(4000 BYTE),
- 
 
122 
	"IMG_ENABLED" VARCHAR2(1000 BYTE),
- 
 
123 
	"IMG_DISABLED" VARCHAR2(1000 BYTE),
- 
 
124 
	"HINT" VARCHAR2(50 BYTE),
- 
 
125 
	"VISIBLE" CHAR(1 BYTE),
- 
 
126 
	"ACTIVE" CHAR(1 BYTE),
- 
 
127 
	"IS_READONLY_ACTION" CHAR(1 BYTE)
 - 
 
128 
   ) SEGMENT CREATION IMMEDIATE
- 
 
129 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
 - 
 
130 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 - 
 
131 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 - 
 
132 
  TABLESPACE "RELEASEM_DATA" ;
 - 
 
133 
--------------------------------------------------------
 - 
 
134 
--  DDL for Table LOGIN_TRAIL
 113 
--  DDL for Table LOGIN_TRAIL
135 
--------------------------------------------------------
 114 
--------------------------------------------------------
136 
 
 115 
 
137 
  CREATE TABLE "ACCESS_MANAGER"."LOGIN_TRAIL"
116 
  CREATE TABLE "ACCESS_MANAGER"."LOGIN_TRAIL"
138 
   (	"ENUM_EVENT" NUMBER,
117 
   (	"ENUM_EVENT" NUMBER,
Line 244... Line 223...
244 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
 223 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
245 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 224 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
246 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 225 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
247 
  TABLESPACE "RELEASEM_DATA" ;
 226 
  TABLESPACE "RELEASEM_DATA" ;
248 
--------------------------------------------------------
 227 
--------------------------------------------------------
249 
--  DDL for Table VALIDATION_RULES
 - 
 
250 
--------------------------------------------------------
 - 
 
251 
 
 - 
 
252 
  CREATE TABLE "ACCESS_MANAGER"."VALIDATION_RULES"
- 
 
253 
   (	"FIELD_NAME" VARCHAR2(1000 BYTE),
- 
 
254 
	"IS_REQUIRED" CHAR(1 BYTE),
- 
 
255 
	"IS_NUMERIC" CHAR(1 BYTE),
- 
 
256 
	"MIN_NUMERIC_VALUE" NUMBER,
- 
 
257 
	"MAX_NUMERIC_VALUE" NUMBER,
- 
 
258 
	"IS_DATE" CHAR(1 BYTE),
- 
 
259 
	"START_DATE" DATE,
- 
 
260 
	"END_DATE" DATE,
- 
 
261 
	"MIN_STRING_LENGTH" NUMBER,
- 
 
262 
	"MAX_STRING_LENGTH" NUMBER,
- 
 
263 
	"REGEXP" VARCHAR2(4000 BYTE),
- 
 
264 
	"REGEXP_DESCRIPTION" VARCHAR2(50 BYTE)
 - 
 
265 
   ) SEGMENT CREATION IMMEDIATE
- 
 
266 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
 - 
 
267 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 - 
 
268 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 - 
 
269 
  TABLESPACE "RELEASEM_DATA" ;
 - 
 
270 
--------------------------------------------------------
 - 
 
271 
--  DDL for View CONTROLOBJECTS_VS_ROLES
 228 
--  DDL for View CONTROLOBJECTS_VS_ROLES
272 
--------------------------------------------------------
 229 
--------------------------------------------------------
273 
 
 230 
 
274 
  CREATE OR REPLACE FORCE VIEW "ACCESS_MANAGER"."CONTROLOBJECTS_VS_ROLES" ("APPLICATION ID", "APPLICATION NAME", "OBJECT_ID", "OBJECT NAME", "OBJECT DESCRIPTION", "ROLE ID", "ROLE NAME") AS
231 
  CREATE OR REPLACE FORCE VIEW "ACCESS_MANAGER"."CONTROLOBJECTS_VS_ROLES" ("APPLICATION ID", "APPLICATION NAME", "OBJECT_ID", "OBJECT NAME", "OBJECT DESCRIPTION", "ROLE ID", "ROLE NAME") AS
275 
  select distinct app.app_id, app.application_name, co.obj_id, co.obj_name, co.obj_description, ro.role_id, ro.role_name
 232 
  select distinct app.app_id, app.application_name, co.obj_id, co.obj_name, co.obj_description, ro.role_id, ro.role_name
Line 278... Line 235...
278 
and app.app_id=ro.app_id
 235 
and app.app_id=ro.app_id
279 
and ro.role_id=rp.role_id
 236 
and ro.role_id=rp.role_id
280 
and rp.obj_id=co.obj_id
 237 
and rp.obj_id=co.obj_id
281 
order by co.obj_name;
 238 
order by co.obj_name;
282 
--------------------------------------------------------
 239 
--------------------------------------------------------
- 
 
 240 
--  DDL for Index UNQ_APPLICATIONS
- 
 
 241 
--------------------------------------------------------
- 
 
 242 
 
- 
 
 243 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_APPLICATIONS" ON "ACCESS_MANAGER"."APPLICATIONS" ("APPLICATION_NAME")
- 
 
 244 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 245 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 246 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 247 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 248 
--------------------------------------------------------
283 
--  DDL for Index UNQ_PERMISSION_TYPES
 249 
--  DDL for Index UNQ_PERMISSION_TYPES
284 
--------------------------------------------------------
 250 
--------------------------------------------------------
285 
 
 251 
 
286 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_PERMISSION_TYPES" ON "ACCESS_MANAGER"."PERMISSION_TYPES" ("PERM_NAME")
252 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_PERMISSION_TYPES" ON "ACCESS_MANAGER"."PERMISSION_TYPES" ("PERM_NAME")
287 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
253 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
Line 296... Line 262...
296 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
262 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
297 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 263 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
298 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 264 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
299 
  TABLESPACE "RELEASEM_INDX" ;
 265 
  TABLESPACE "RELEASEM_INDX" ;
300 
--------------------------------------------------------
 266 
--------------------------------------------------------
- 
 
 267 
--  DDL for Index UNQ_PAGE_COBJ
- 
 
 268 
--------------------------------------------------------
- 
 
 269 
 
- 
 
 270 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_PAGE_COBJ" ON "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" ("PAGE_ID", "OBJ_ID")
- 
 
 271 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 272 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 273 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 274 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 275 
--------------------------------------------------------
301 
--  DDL for Index PK_ROLES
 276 
--  DDL for Index PK_ROLES
302 
--------------------------------------------------------
 277 
--------------------------------------------------------
303 
 
 278 
 
304 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_ROLES" ON "ACCESS_MANAGER"."ROLES" ("ROLE_ID")
279 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_ROLES" ON "ACCESS_MANAGER"."ROLES" ("ROLE_ID")
305 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
280 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
Line 323... Line 298...
323 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
298 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
324 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 299 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
325 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 300 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
326 
  TABLESPACE "RELEASEM_INDX" ;
 301 
  TABLESPACE "RELEASEM_INDX" ;
327 
--------------------------------------------------------
 302 
--------------------------------------------------------
328 
--  DDL for Index UNQ_VALIDATION_RULES
 303 
--  DDL for Index PK_PERMISSION_TYPES
329 
--------------------------------------------------------
 304 
--------------------------------------------------------
330 
 
 305 
 
331 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_VALIDATION_RULES" ON "ACCESS_MANAGER"."VALIDATION_RULES" ("FIELD_NAME")
306 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_PERMISSION_TYPES" ON "ACCESS_MANAGER"."PERMISSION_TYPES" ("PERM_ID")
332 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
307 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
333 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 308 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
334 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 309 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
335 
  TABLESPACE "RELEASEM_INDX" ;
 310 
  TABLESPACE "RELEASEM_INDX" ;
336 
--------------------------------------------------------
 311 
--------------------------------------------------------
Line 350... Line 325...
350 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
325 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
351 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 326 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
352 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 327 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
353 
  TABLESPACE "RELEASEM_INDX" ;
 328 
  TABLESPACE "RELEASEM_INDX" ;
354 
--------------------------------------------------------
 329 
--------------------------------------------------------
355 
--  DDL for Index PK_APPLICATIONS
 - 
 
356 
--------------------------------------------------------
 - 
 
357 
 
 - 
 
358 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_APPLICATIONS" ON "ACCESS_MANAGER"."APPLICATIONS" ("APP_ID")
- 
 
359 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
360 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 - 
 
361 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 - 
 
362 
  TABLESPACE "RELEASEM_INDX" ;
 - 
 
363 
--------------------------------------------------------
 - 
 
364 
--  DDL for Index UNQ_ABTN_DEF
 - 
 
365 
--------------------------------------------------------
 - 
 
366 
 
 - 
 
367 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_ABTN_DEF" ON "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" ("ABTN_NAME")
- 
 
368 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
369 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 - 
 
370 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 - 
 
371 
  TABLESPACE "RELEASEM_INDX" ;
 - 
 
372 
--------------------------------------------------------
 - 
 
373 
--  DDL for Index PK_DEF_ACTION_BUTTONS
 - 
 
374 
--------------------------------------------------------
 - 
 
375 
 
 - 
 
376 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_DEF_ACTION_BUTTONS" ON "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" ("ABTN_ID")
- 
 
377 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
378 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 - 
 
379 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 - 
 
380 
  TABLESPACE "RELEASEM_INDX" ;
 - 
 
381 
--------------------------------------------------------
 - 
 
382 
--  DDL for Index UNQ_DATA_PERM
 - 
 
383 
--------------------------------------------------------
 - 
 
384 
 
 - 
 
385 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_DATA_PERM" ON "ACCESS_MANAGER"."DATA_PERMISSIONS" ("DT_ID", "ROLE_ID", "REF_COLUMN_VAL", "PERM_ID")
- 
 
386 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
387 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 - 
 
388 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 - 
 
389 
  TABLESPACE "RELEASEM_INDX" ;
 - 
 
390 
--------------------------------------------------------
 - 
 
391 
--  DDL for Index UNQ_CONTROL_OBJ
 - 
 
392 
--------------------------------------------------------
 - 
 
393 
 
 - 
 
394 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_CONTROL_OBJ" ON "ACCESS_MANAGER"."CONTROL_OBJECTS" ("APP_ID", "OBJ_NAME")
- 
 
395 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
396 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 - 
 
397 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 - 
 
398 
  TABLESPACE "RELEASEM_INDX" ;
 - 
 
399 
--------------------------------------------------------
 - 
 
400 
--  DDL for Index UNQ_APPLICATIONS
 - 
 
401 
--------------------------------------------------------
 - 
 
402 
 
 - 
 
403 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_APPLICATIONS" ON "ACCESS_MANAGER"."APPLICATIONS" ("APPLICATION_NAME")
- 
 
404 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
405 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 - 
 
406 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 - 
 
407 
  TABLESPACE "RELEASEM_INDX" ;
 - 
 
408 
--------------------------------------------------------
 - 
 
409 
--  DDL for Index UNQ_PAGE_COBJ
 330 
--  DDL for Index INX_CLIENT_IP
410 
--------------------------------------------------------
 331 
--------------------------------------------------------
411 
 
 332 
 
412 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_PAGE_COBJ" ON "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" ("PAGE_ID", "OBJ_ID")
333 
  CREATE INDEX "ACCESS_MANAGER"."INX_CLIENT_IP" ON "ACCESS_MANAGER"."LOGIN_TRAIL" ("CLIENT_IP")
413 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
334 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
414 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 335 
  STORAGE(INITIAL 6291456 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
415 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 336 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
416 
  TABLESPACE "RELEASEM_INDX" ;
 337 
  TABLESPACE "RELEASEM_INDX" ;
417 
--------------------------------------------------------
 338 
--------------------------------------------------------
418 
--  DDL for Index PK_PERMISSION_TYPES
 339 
--  DDL for Index PK_APPLICATIONS
419 
--------------------------------------------------------
 340 
--------------------------------------------------------
420 
 
 341 
 
421 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_PERMISSION_TYPES" ON "ACCESS_MANAGER"."PERMISSION_TYPES" ("PERM_ID")
342 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_APPLICATIONS" ON "ACCESS_MANAGER"."APPLICATIONS" ("APP_ID")
422 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
343 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
423 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 344 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
424 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 345 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
425 
  TABLESPACE "RELEASEM_INDX" ;
 346 
  TABLESPACE "RELEASEM_INDX" ;
426 
--------------------------------------------------------
 347 
--------------------------------------------------------
427 
--  DDL for Index INX_CLIENT_IP
 - 
 
428 
--------------------------------------------------------
 - 
 
429 
 
 - 
 
430 
  CREATE INDEX "ACCESS_MANAGER"."INX_CLIENT_IP" ON "ACCESS_MANAGER"."LOGIN_TRAIL" ("CLIENT_IP")
- 
 
431 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
432 
  STORAGE(INITIAL 6291456 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 - 
 
433 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 - 
 
434 
  TABLESPACE "RELEASEM_INDX" ;
 - 
 
435 
--------------------------------------------------------
 - 
 
436 
--  DDL for Index PK_CONTROL_OBJECTS
 348 
--  DDL for Index PK_CONTROL_OBJECTS
437 
--------------------------------------------------------
 349 
--------------------------------------------------------
438 
 
 350 
 
439 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_CONTROL_OBJECTS" ON "ACCESS_MANAGER"."CONTROL_OBJECTS" ("OBJ_ID")
351 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."PK_CONTROL_OBJECTS" ON "ACCESS_MANAGER"."CONTROL_OBJECTS" ("OBJ_ID")
440 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
352 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
Line 494... Line 406...
494 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
406 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
495 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 407 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
496 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 408 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
497 
  TABLESPACE "RELEASEM_INDX" ;
 409 
  TABLESPACE "RELEASEM_INDX" ;
498 
--------------------------------------------------------
 410 
--------------------------------------------------------
- 
 
 411 
--  DDL for Index UNQ_DATA_PERM
- 
 
 412 
--------------------------------------------------------
- 
 
 413 
 
- 
 
 414 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_DATA_PERM" ON "ACCESS_MANAGER"."DATA_PERMISSIONS" ("DT_ID", "ROLE_ID", "REF_COLUMN_VAL", "PERM_ID")
- 
 
 415 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 416 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 417 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 418 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 419 
--------------------------------------------------------
499 
--  DDL for Index UNQ_ROLE_OBJ_PERM
 420 
--  DDL for Index UNQ_ROLE_OBJ_PERM
500 
--------------------------------------------------------
 421 
--------------------------------------------------------
501 
 
 422 
 
502 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_ROLE_OBJ_PERM" ON "ACCESS_MANAGER"."ROLE_PRIVILEGES" ("ROLE_ID", "OBJ_ID", "PERM_ID")
423 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_ROLE_OBJ_PERM" ON "ACCESS_MANAGER"."ROLE_PRIVILEGES" ("ROLE_ID", "OBJ_ID", "PERM_ID")
503 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
424 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
504 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 425 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
505 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 426 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
506 
  TABLESPACE "RELEASEM_INDX" ;
 427 
  TABLESPACE "RELEASEM_INDX" ;
507 
--------------------------------------------------------
 428 
--------------------------------------------------------
- 
 
 429 
--  DDL for Index UNQ_CONTROL_OBJ
- 
 
 430 
--------------------------------------------------------
- 
 
 431 
 
- 
 
 432 
  CREATE UNIQUE INDEX "ACCESS_MANAGER"."UNQ_CONTROL_OBJ" ON "ACCESS_MANAGER"."CONTROL_OBJECTS" ("APP_ID", "OBJ_NAME")
- 
 
 433 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
 434 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- 
 
 435 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- 
 
 436 
  TABLESPACE "RELEASEM_INDX" ;
- 
 
 437 
--------------------------------------------------------
508 
--  Constraints for Table DATA_TABLES
 438 
--  Constraints for Table DATA_TABLES
509 
--------------------------------------------------------
 439 
--------------------------------------------------------
510 
 
 440 
 
- 
 
 441 
  ALTER TABLE "ACCESS_MANAGER"."DATA_TABLES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
511 
  ALTER TABLE "ACCESS_MANAGER"."DATA_TABLES" ADD CONSTRAINT "PK_DATA_TABLES" PRIMARY KEY ("DT_ID")
 442 
  ALTER TABLE "ACCESS_MANAGER"."DATA_TABLES" ADD CONSTRAINT "PK_DATA_TABLES" PRIMARY KEY ("DT_ID")
512 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
443 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
513 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 444 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
514 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 445 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
515 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
 446 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
Line 529... Line 460...
529 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
 460 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
530 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("IS_RUNNING" NOT NULL ENABLE);
 461 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("IS_RUNNING" NOT NULL ENABLE);
531 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("ACRONYM" NOT NULL ENABLE);
 462 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("ACRONYM" NOT NULL ENABLE);
532 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("APPLICATION_NAME" NOT NULL ENABLE);
 463 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("APPLICATION_NAME" NOT NULL ENABLE);
533 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("APP_ID" NOT NULL ENABLE);
 464 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" MODIFY ("APP_ID" NOT NULL ENABLE);
- 
 
 465 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATIONS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
534 
--------------------------------------------------------
 466 
--------------------------------------------------------
535 
--  Constraints for Table PERMISSION_TYPES
 467 
--  Constraints for Table PERMISSION_TYPES
536 
--------------------------------------------------------
 468 
--------------------------------------------------------
537 
 
 469 
 
538 
  ALTER TABLE "ACCESS_MANAGER"."PERMISSION_TYPES" ADD CONSTRAINT "PK_PERMISSION_TYPES" PRIMARY KEY ("PERM_ID")
 470 
  ALTER TABLE "ACCESS_MANAGER"."PERMISSION_TYPES" ADD CONSTRAINT "PK_PERMISSION_TYPES" PRIMARY KEY ("PERM_ID")
Line 540... Line 472...
540 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 472 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
541 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 473 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
542 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
 474 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
543 
  ALTER TABLE "ACCESS_MANAGER"."PERMISSION_TYPES" MODIFY ("PERM_NAME" NOT NULL ENABLE);
 475 
  ALTER TABLE "ACCESS_MANAGER"."PERMISSION_TYPES" MODIFY ("PERM_NAME" NOT NULL ENABLE);
544 
  ALTER TABLE "ACCESS_MANAGER"."PERMISSION_TYPES" MODIFY ("PERM_ID" NOT NULL ENABLE);
 476 
  ALTER TABLE "ACCESS_MANAGER"."PERMISSION_TYPES" MODIFY ("PERM_ID" NOT NULL ENABLE);
- 
 
 477 
  ALTER TABLE "ACCESS_MANAGER"."PERMISSION_TYPES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
545 
--------------------------------------------------------
 478 
--------------------------------------------------------
546 
--  Constraints for Table USER_APPLICATIONS
 479 
--  Constraints for Table USER_APPLICATIONS
547 
--------------------------------------------------------
 480 
--------------------------------------------------------
548 
 
 481 
 
549 
  ALTER TABLE "ACCESS_MANAGER"."USER_APPLICATIONS" MODIFY ("APP_ID" NOT NULL ENABLE);
 482 
  ALTER TABLE "ACCESS_MANAGER"."USER_APPLICATIONS" MODIFY ("APP_ID" NOT NULL ENABLE);
550 
  ALTER TABLE "ACCESS_MANAGER"."USER_APPLICATIONS" MODIFY ("USER_ID" NOT NULL ENABLE);
 483 
  ALTER TABLE "ACCESS_MANAGER"."USER_APPLICATIONS" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 484 
  ALTER TABLE "ACCESS_MANAGER"."USER_APPLICATIONS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
551 
--------------------------------------------------------
 485 
--------------------------------------------------------
552 
--  Constraints for Table USER_ROLES
 486 
--  Constraints for Table USER_ROLES
553 
--------------------------------------------------------
 487 
--------------------------------------------------------
554 
 
 488 
 
555 
  ALTER TABLE "ACCESS_MANAGER"."USER_ROLES" MODIFY ("ROLE_ID" NOT NULL ENABLE);
 489 
  ALTER TABLE "ACCESS_MANAGER"."USER_ROLES" MODIFY ("ROLE_ID" NOT NULL ENABLE);
556 
  ALTER TABLE "ACCESS_MANAGER"."USER_ROLES" MODIFY ("USER_ID" NOT NULL ENABLE);
 490 
  ALTER TABLE "ACCESS_MANAGER"."USER_ROLES" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 491 
  ALTER TABLE "ACCESS_MANAGER"."USER_ROLES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
557 
--------------------------------------------------------
 492 
--------------------------------------------------------
558 
--  Constraints for Table APPLICATION_PAGES
 493 
--  Constraints for Table APPLICATION_PAGES
559 
--------------------------------------------------------
 494 
--------------------------------------------------------
560 
 
 495 
 
- 
 
 496 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATION_PAGES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
561 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATION_PAGES" ADD CONSTRAINT "PK_APPLICATION_PAGES" PRIMARY KEY ("PAGE_ID")
 497 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATION_PAGES" ADD CONSTRAINT "PK_APPLICATION_PAGES" PRIMARY KEY ("PAGE_ID")
562 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
498 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
563 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 499 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
564 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 500 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
565 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
 501 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
Line 576... Line 512...
576 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 512 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
577 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
 513 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
578 
  ALTER TABLE "ACCESS_MANAGER"."USERS" MODIFY ("USER_NAME" NOT NULL ENABLE);
 514 
  ALTER TABLE "ACCESS_MANAGER"."USERS" MODIFY ("USER_NAME" NOT NULL ENABLE);
579 
  ALTER TABLE "ACCESS_MANAGER"."USERS" MODIFY ("FULL_NAME" NOT NULL ENABLE);
 515 
  ALTER TABLE "ACCESS_MANAGER"."USERS" MODIFY ("FULL_NAME" NOT NULL ENABLE);
580 
  ALTER TABLE "ACCESS_MANAGER"."USERS" MODIFY ("USER_ID" NOT NULL ENABLE);
 516 
  ALTER TABLE "ACCESS_MANAGER"."USERS" MODIFY ("USER_ID" NOT NULL ENABLE);
- 
 
 517 
  ALTER TABLE "ACCESS_MANAGER"."USERS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
581 
--------------------------------------------------------
 518 
--------------------------------------------------------
582 
--  Constraints for Table CONTROL_OBJECTS
 519 
--  Constraints for Table CONTROL_OBJECTS
583 
--------------------------------------------------------
 520 
--------------------------------------------------------
584 
 
 521 
 
- 
 
 522 
  ALTER TABLE "ACCESS_MANAGER"."CONTROL_OBJECTS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
585 
  ALTER TABLE "ACCESS_MANAGER"."CONTROL_OBJECTS" ADD CONSTRAINT "PK_CONTROL_OBJECTS" PRIMARY KEY ("OBJ_ID")
 523 
  ALTER TABLE "ACCESS_MANAGER"."CONTROL_OBJECTS" ADD CONSTRAINT "PK_CONTROL_OBJECTS" PRIMARY KEY ("OBJ_ID")
586 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
524 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
587 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 525 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
588 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 526 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
589 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
 527 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
Line 595... Line 533...
595 
--------------------------------------------------------
 533 
--------------------------------------------------------
596 
 
 534 
 
597 
  ALTER TABLE "ACCESS_MANAGER"."LOGIN_TRAIL" MODIFY ("STAMP" NOT NULL ENABLE);
 535 
  ALTER TABLE "ACCESS_MANAGER"."LOGIN_TRAIL" MODIFY ("STAMP" NOT NULL ENABLE);
598 
  ALTER TABLE "ACCESS_MANAGER"."LOGIN_TRAIL" MODIFY ("USER_NAME" NOT NULL ENABLE);
 536 
  ALTER TABLE "ACCESS_MANAGER"."LOGIN_TRAIL" MODIFY ("USER_NAME" NOT NULL ENABLE);
599 
  ALTER TABLE "ACCESS_MANAGER"."LOGIN_TRAIL" MODIFY ("ENUM_EVENT" NOT NULL ENABLE);
 537 
  ALTER TABLE "ACCESS_MANAGER"."LOGIN_TRAIL" MODIFY ("ENUM_EVENT" NOT NULL ENABLE);
- 
 
 538 
  ALTER TABLE "ACCESS_MANAGER"."LOGIN_TRAIL" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
600 
--------------------------------------------------------
 539 
--------------------------------------------------------
601 
--  Constraints for Table ROLE_PRIVILEGES
 540 
--  Constraints for Table ROLE_PRIVILEGES
602 
--------------------------------------------------------
 541 
--------------------------------------------------------
603 
 
 542 
 
604 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("PERM_VALUE" NOT NULL ENABLE);
 543 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("PERM_VALUE" NOT NULL ENABLE);
605 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("PERM_ID" NOT NULL ENABLE);
 544 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("PERM_ID" NOT NULL ENABLE);
606 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("OBJ_ID" NOT NULL ENABLE);
 545 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("OBJ_ID" NOT NULL ENABLE);
607 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("ROLE_ID" NOT NULL ENABLE);
 546 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" MODIFY ("ROLE_ID" NOT NULL ENABLE);
- 
 
 547 
  ALTER TABLE "ACCESS_MANAGER"."ROLE_PRIVILEGES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
608 
--------------------------------------------------------
 548 
--------------------------------------------------------
609 
--  Constraints for Table PAGE_CONTROL_OBJECTS
 549 
--  Constraints for Table PAGE_CONTROL_OBJECTS
610 
--------------------------------------------------------
 550 
--------------------------------------------------------
611 
 
 551 
 
612 
  ALTER TABLE "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" MODIFY ("OBJ_ID" NOT NULL ENABLE);
 552 
  ALTER TABLE "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" MODIFY ("OBJ_ID" NOT NULL ENABLE);
613 
  ALTER TABLE "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" MODIFY ("PAGE_ID" NOT NULL ENABLE);
 553 
  ALTER TABLE "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" MODIFY ("PAGE_ID" NOT NULL ENABLE);
- 
 
 554 
  ALTER TABLE "ACCESS_MANAGER"."PAGE_CONTROL_OBJECTS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
614 
--------------------------------------------------------
 555 
--------------------------------------------------------
615 
--  Constraints for Table DATA_PERMISSIONS
 556 
--  Constraints for Table DATA_PERMISSIONS
616 
--------------------------------------------------------
 557 
--------------------------------------------------------
617 
 
 558 
 
- 
 
 559 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
618 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("PERM_VALUE" NOT NULL ENABLE);
 560 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("PERM_VALUE" NOT NULL ENABLE);
619 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("PERM_ID" NOT NULL ENABLE);
 561 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("PERM_ID" NOT NULL ENABLE);
620 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("REF_COLUMN_VAL" NOT NULL ENABLE);
 562 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("REF_COLUMN_VAL" NOT NULL ENABLE);
621 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("ROLE_ID" NOT NULL ENABLE);
 563 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("ROLE_ID" NOT NULL ENABLE);
622 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("DT_ID" NOT NULL ENABLE);
 564 
  ALTER TABLE "ACCESS_MANAGER"."DATA_PERMISSIONS" MODIFY ("DT_ID" NOT NULL ENABLE);
623 
--------------------------------------------------------
 565 
--------------------------------------------------------
624 
--  Constraints for Table VALIDATION_RULES
 - 
 
625 
--------------------------------------------------------
 - 
 
626 
 
 - 
 
627 
  ALTER TABLE "ACCESS_MANAGER"."VALIDATION_RULES" MODIFY ("IS_REQUIRED" NOT NULL ENABLE);
 - 
 
628 
  ALTER TABLE "ACCESS_MANAGER"."VALIDATION_RULES" MODIFY ("FIELD_NAME" NOT NULL ENABLE);
 - 
 
629 
--------------------------------------------------------
 - 
 
630 
--  Constraints for Table ROLES
 566 
--  Constraints for Table ROLES
631 
--------------------------------------------------------
 567 
--------------------------------------------------------
632 
 
 568 
 
633 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" ADD CONSTRAINT "PK_ROLES" PRIMARY KEY ("ROLE_ID")
 569 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" ADD CONSTRAINT "PK_ROLES" PRIMARY KEY ("ROLE_ID")
634 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
570 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
Line 636... Line 572...
636 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 572 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
637 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
 573 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
638 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" MODIFY ("ROLE_NAME" NOT NULL ENABLE);
 574 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" MODIFY ("ROLE_NAME" NOT NULL ENABLE);
639 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" MODIFY ("APP_ID" NOT NULL ENABLE);
 575 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" MODIFY ("APP_ID" NOT NULL ENABLE);
640 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" MODIFY ("ROLE_ID" NOT NULL ENABLE);
 576 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" MODIFY ("ROLE_ID" NOT NULL ENABLE);
641 
--------------------------------------------------------
 - 
 
642 
--  Constraints for Table DEF_ACTION_BUTTONS
 - 
 
643 
--------------------------------------------------------
 - 
 
644 
 
 - 
 
645 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" ADD CONSTRAINT "PK_DEF_ACTION_BUTTONS" PRIMARY KEY ("ABTN_ID")
 - 
 
646 
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- 
 
647 
  STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
 - 
 
648 
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
 - 
 
649 
  TABLESPACE "RELEASEM_INDX"  ENABLE;
 - 
 
650 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" MODIFY ("IS_READONLY_ACTION" NOT NULL ENABLE);
 - 
 
651 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" MODIFY ("ACTIVE" NOT NULL ENABLE);
 - 
 
652 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" MODIFY ("VISIBLE" NOT NULL ENABLE);
 577 
  ALTER TABLE "ACCESS_MANAGER"."ROLES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
653 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" MODIFY ("ABTN_NAME" NOT NULL ENABLE);
 - 
 
654 
  ALTER TABLE "ACCESS_MANAGER"."DEF_ACTION_BUTTONS" MODIFY ("ABTN_ID" NOT NULL ENABLE);
 - 
 
655 
--------------------------------------------------------
 578 
--------------------------------------------------------
656 
--  Ref Constraints for Table APPLICATION_PAGES
 579 
--  Ref Constraints for Table APPLICATION_PAGES
657 
--------------------------------------------------------
 580 
--------------------------------------------------------
658 
 
 581 
 
659 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATION_PAGES" ADD CONSTRAINT "FK_APP_PAGE_REF_APP" FOREIGN KEY ("APP_ID")
 582 
  ALTER TABLE "ACCESS_MANAGER"."APPLICATION_PAGES" ADD CONSTRAINT "FK_APP_PAGE_REF_APP" FOREIGN KEY ("APP_ID")