You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@oozie.apache.org by rk...@apache.org on 2017/03/10 20:24:37 UTC
[1/2] oozie git commit: OOZIE-1887 Remove the utils dir (kvntrieu via
rkanter)
Repository: oozie
Updated Branches:
refs/heads/master c8748d221 -> abb2e186e
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql b/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql
deleted file mode 100644
index 9b7a1db..0000000
--- a/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql
+++ /dev/null
@@ -1,20 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-ALTER TABLE WF_ACTIONS ADD USER_RETRY_COUNT NUMBER DEFAULT 0;
-ALTER TABLE WF_ACTIONS ADD USER_RETRY_MAX NUMBER DEFAULT 0;
-ALTER TABLE WF_ACTIONS ADD USER_RETRY_INTERVAL NUMBER DEFAULT 0;
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql b/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql
deleted file mode 100644
index 7ad0546..0000000
--- a/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql
+++ /dev/null
@@ -1,37 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-# please replace "OOZIEDB" to your schema name
-
-UPDATE OOZIEDB.COORD_JOBS
-SET STATUS = 'RUNNING',PENDING = 1
-WHERE ID IN
-(
-SELECT JOB_ID FROM COORD_ACTIONS WHERE JOB_ID IN (
-SELECT ID FROM COORD_JOBS WHERE STATUS = 'SUCCEEDED') AND (STATUS != 'FAILED' AND
-STATUS != 'SUCCEEDED' AND STATUS != 'KILLED' AND STATUS != 'TIMEDOUT')
-);
-
-UPDATE OOZIEDB.COORD_JOBS SET STATUS = 'RUNNING' WHERE STATUS = 'PREMATER';
-
-UPDATE OOZIEDB.COORD_ACTIONS
-SET STATUS = 'SUSPENDED'
-WHERE ID IN(
-SELECT A.ID FROM COORD_ACTIONS A, WF_JOBS B WHERE A.EXTERNAL_ID = B.ID
-AND B.STATUS = 'SUSPENDED' AND A.STATUS = 'RUNNING'
-);
[2/2] oozie git commit: OOZIE-1887 Remove the utils dir (kvntrieu via
rkanter)
Posted by rk...@apache.org.
OOZIE-1887 Remove the utils dir (kvntrieu via rkanter)
Project: http://git-wip-us.apache.org/repos/asf/oozie/repo
Commit: http://git-wip-us.apache.org/repos/asf/oozie/commit/abb2e186
Tree: http://git-wip-us.apache.org/repos/asf/oozie/tree/abb2e186
Diff: http://git-wip-us.apache.org/repos/asf/oozie/diff/abb2e186
Branch: refs/heads/master
Commit: abb2e186ec0f2f200a0d64ef5174caf023b17424
Parents: c8748d2
Author: Robert Kanter <rk...@apache.org>
Authored: Fri Mar 10 12:24:30 2017 -0800
Committer: Robert Kanter <rk...@apache.org>
Committed: Fri Mar 10 12:24:30 2017 -0800
----------------------------------------------------------------------
release-log.txt | 1 +
utils/dbutils/updatescripts/dbscripts-2.2.5.sql | 330 ---------------
utils/dbutils/updatescripts/dbscripts-3.0.0.sql | 409 ------------------
utils/dbutils/updatescripts/dbscripts-3.0.1.sql | 414 ------------------
utils/dbutils/updatescripts/dbscripts-3.1.0.sql | 417 -------------------
utils/dbutils/updatescripts/readme.txt | 7 -
.../updatescripts-2.x-to-3.0.0.sql | 101 -----
.../updatescripts-2.x-to-3.0.1.sql | 104 -----
.../updatescripts-3.0.0-to-3.0.1.sql | 23 -
.../updatescripts-3.x-to-3.1.0.sql | 20 -
.../upgradescript-2.x-to-3.0.0.sql | 37 --
11 files changed, 1 insertion(+), 1862 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/release-log.txt
----------------------------------------------------------------------
diff --git a/release-log.txt b/release-log.txt
index 5c55cad..b5365f8 100644
--- a/release-log.txt
+++ b/release-log.txt
@@ -1,5 +1,6 @@
-- Oozie 4.4.0 release (trunk - unreleased)
+OOZIE-1887 Remove the utils dir (kvntrieu via rkanter)
OOZIE-2540 Create a PySpark example (abhishekbafna via rkanter)
OOZIE-807 Docs can be explicit about multiple sub-workflow definitions being possible (qwertymaniac via rkanter)
OOZIE-2811 Add support for filtering out properties from SparkConfigurationService (gezapeti via rkanter)
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/dbscripts-2.2.5.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/dbscripts-2.2.5.sql b/utils/dbutils/updatescripts/dbscripts-2.2.5.sql
deleted file mode 100644
index 46b5e90..0000000
--- a/utils/dbutils/updatescripts/dbscripts-2.2.5.sql
+++ /dev/null
@@ -1,330 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-# please replace "OOZIEDB" to your schema name
-
-CREATE TABLE "OOZIEDB"."VALIDATE_CONN"
- ("ID" NUMBER NOT NULL ENABLE,
-"DUMMY" NUMBER,
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION DEFERRED
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-TABLESPACE "OOZIEDB";
-
-CREATE TABLE "OOZIEDB"."COORD_ACTIONS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"ACTION_NUMBER" NUMBER,
-"ACTION_XML" CLOB,
-"CONSOLE_URL" VARCHAR2(255),
-"CREATED_CONF" CLOB,
-"ERROR_CODE" VARCHAR2(255),
-"ERROR_MESSAGE" VARCHAR2(255),
-"EXTERNAL_STATUS" VARCHAR2(255),
-"MISSING_DEPENDENCIES" CLOB,
-"RUN_CONF" CLOB,
-"TIME_OUT" NUMBER,
-"TRACKER_URI" VARCHAR2(255),
-"JOB_TYPE" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"CREATED_TIME" TIMESTAMP (6),
-"EXTERNAL_ID" VARCHAR2(255),
-"JOB_ID" VARCHAR2(255),
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"NOMINAL_TIME" TIMESTAMP (6),
-"RERUN_TIME" TIMESTAMP (6),
-"SLA_XML" CLOB,
-"STATUS" VARCHAR2(255),
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("ACTION_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("CREATED_CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("MISSING_DEPENDENCIES") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("RUN_CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-CREATE TABLE "OOZIEDB"."COORD_JOBS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"APP_NAME" VARCHAR2(255),
-"APP_PATH" VARCHAR2(255),
-"BUNDLE_ID" VARCHAR2(255),
-"CONCURRENCY" NUMBER,
-"CONF" CLOB,
-"EXTERNAL_ID" VARCHAR2(255),
-"FREQUENCY" NUMBER,
-"GROUP_NAME" VARCHAR2(255),
-"LAST_ACTION_NUMBER" NUMBER,
-"TIME_OUT" NUMBER,
-"TIME_ZONE" VARCHAR2(255),
-"USER_NAME" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"AUTH_TOKEN" CLOB,
-"CREATED_TIME" TIMESTAMP (6),
-"END_TIME" TIMESTAMP (6),
-"EXECUTION" VARCHAR2(255),
-"JOB_XML" CLOB,
-"LAST_ACTION" TIMESTAMP (6),
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"NEXT_MATD_TIME" TIMESTAMP (6),
-"ORIG_JOB_XML" CLOB,
-"PAUSE_TIME" TIMESTAMP (6),
-"SLA_XML" CLOB,
-"START_TIME" TIMESTAMP (6),
-"STATUS" VARCHAR2(255),
-"SUSPENDED_TIME" TIMESTAMP (6),
-"TIME_UNIT" VARCHAR2(255),
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("JOB_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ORIG_JOB_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-CREATE TABLE "OOZIEDB"."SLA_EVENTS"
- ("EVENT_ID" NUMBER NOT NULL ENABLE,
-"ALERT_CONTACT" VARCHAR2(255),
-"ALERT_FREQUENCY" VARCHAR2(255),
-"ALERT_PERCENTAGE" VARCHAR2(255),
-"APP_NAME" VARCHAR2(255),
-"DEV_CONTACT" VARCHAR2(255),
-"GROUP_NAME" VARCHAR2(255),
-"JOB_DATA" CLOB,
-"NOTIFICATION_MSG" CLOB,
-"PARENT_CLIENT_ID" VARCHAR2(255),
-"PARENT_SLA_ID" VARCHAR2(255),
-"QA_CONTACT" VARCHAR2(255),
-"SE_CONTACT" VARCHAR2(255),
-"SLA_ID" VARCHAR2(255),
-"UPSTREAM_APPS" CLOB,
-"USER_NAME" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"APP_TYPE" VARCHAR2(255),
-"EVENT_TYPE" VARCHAR2(255),
-"EXPECTED_END" TIMESTAMP (6),
-"EXPECTED_START" TIMESTAMP (6),
-"JOB_STATUS" VARCHAR2(255),
-"STATUS_TIMESTAMP" TIMESTAMP (6),
- PRIMARY KEY ("EVENT_ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("JOB_DATA") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("NOTIFICATION_MSG") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("UPSTREAM_APPS") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-CREATE TABLE "OOZIEDB"."WF_ACTIONS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"CONF" CLOB,
-"CONSOLE_URL" VARCHAR2(255),
-"CRED" VARCHAR2(255),
-"DATA" CLOB,
-"ERROR_CODE" VARCHAR2(255),
-"ERROR_MESSAGE" CLOB,
-"EXTERNAL_ID" VARCHAR2(255),
-"EXTERNAL_STATUS" VARCHAR2(255),
-"NAME" VARCHAR2(255),
-"RETRIES" NUMBER,
-"TRACKER_URI" VARCHAR2(255),
-"TRANSITION" VARCHAR2(255),
-"TYPE" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"END_TIME" TIMESTAMP (6),
-"EXECUTION_PATH" VARCHAR2(255),
-"LAST_CHECK_TIME" TIMESTAMP (6),
-"LOG_TOKEN" VARCHAR2(255),
-"PENDING" NUMBER,
-"PENDING_AGE" TIMESTAMP (6),
-"SIGNAL_VALUE" VARCHAR2(255),
-"SLA_XML" CLOB,
-"START_TIME" TIMESTAMP (6),
-"STATUS" VARCHAR2(255),
-"WF_ID" VARCHAR2(255),
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("DATA") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ERROR_MESSAGE") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-CREATE TABLE "OOZIEDB"."WF_JOBS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"APP_NAME" VARCHAR2(255),
-"APP_PATH" VARCHAR2(255),
-"CONF" CLOB,
-"GROUP_NAME" VARCHAR2(255),
-"PARENTID" VARCHAR2(255),
-"RUN" NUMBER,
-"USER_NAME" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"AUTH_TOKEN" CLOB,
-"CREATED_TIME" TIMESTAMP (6),
-"END_TIME" TIMESTAMP (6),
-"EXTERNAL_ID" VARCHAR2(255),
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"LOG_TOKEN" VARCHAR2(255),
-"PROTO_ACTION_CONF" CLOB,
-"SLA_XML" CLOB,
-"START_TIME" TIMESTAMP (6),
-"STATUS" VARCHAR2(255),
-"WF_INSTANCE" BLOB,
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("PROTO_ACTION_CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("WF_INSTANCE") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-CREATE TABLE "OOZIEDB"."OPENJPA_SEQUENCE_TABLE"
- ("ID" NUMBER NOT NULL ENABLE,
-"SEQUENCE_VALUE" NUMBER,
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION DEFERRED
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-TABLESPACE "OOZIEDB";
-
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/dbscripts-3.0.0.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/dbscripts-3.0.0.sql b/utils/dbutils/updatescripts/dbscripts-3.0.0.sql
deleted file mode 100644
index c7e03fd..0000000
--- a/utils/dbutils/updatescripts/dbscripts-3.0.0.sql
+++ /dev/null
@@ -1,409 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-# please replace "OOZIEDB" to your schema name
-
-CREATE TABLE "OOZIEDB"."VALIDATE_CONN"
- ("ID" NUMBER NOT NULL ENABLE,
-"DUMMY" NUMBER,
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION DEFERRED
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-TABLESPACE "OOZIEDB";
-
-CREATE TABLE "OOZIEDB"."COORD_ACTIONS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"ACTION_NUMBER" NUMBER,
-"ACTION_XML" CLOB,
-"CONSOLE_URL" VARCHAR2(255),
-"CREATED_CONF" CLOB,
-"ERROR_CODE" VARCHAR2(255),
-"ERROR_MESSAGE" VARCHAR2(255),
-"EXTERNAL_STATUS" VARCHAR2(255),
-"MISSING_DEPENDENCIES" CLOB,
-"RUN_CONF" CLOB,
-"TIME_OUT" NUMBER,
-"TRACKER_URI" VARCHAR2(255),
-"JOB_TYPE" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"CREATED_TIME" TIMESTAMP (6),
-"EXTERNAL_ID" VARCHAR2(255),
-"JOB_ID" VARCHAR2(255),
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"NOMINAL_TIME" TIMESTAMP (6),
-"PENDING" NUMBER,
-"RERUN_TIME" TIMESTAMP (6),
-"SLA_XML" CLOB,
-"STATUS" VARCHAR2(255),
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("ACTION_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("CREATED_CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("MISSING_DEPENDENCIES") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("RUN_CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-CREATE TABLE "OOZIEDB"."COORD_JOBS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"APP_NAME" VARCHAR2(255),
-"APP_PATH" VARCHAR2(255),
-"BUNDLE_ID" VARCHAR2(255),
-"CONCURRENCY" NUMBER,
-"CONF" CLOB,
-"EXTERNAL_ID" VARCHAR2(255),
-"FREQUENCY" NUMBER,
-"GROUP_NAME" VARCHAR2(255),
-"LAST_ACTION_NUMBER" NUMBER,
-"TIME_OUT" NUMBER,
-"TIME_ZONE" VARCHAR2(255),
-"USER_NAME" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"AUTH_TOKEN" CLOB,
-"CREATED_TIME" TIMESTAMP (6),
-"END_TIME" TIMESTAMP (6),
-"EXECUTION" VARCHAR2(255),
-"JOB_XML" CLOB,
-"LAST_ACTION" TIMESTAMP (6),
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"NEXT_MATD_TIME" TIMESTAMP (6),
-"ORIG_JOB_XML" CLOB,
-"PAUSE_TIME" TIMESTAMP (6),
-"PENDING" NUMBER,
-"SLA_XML" CLOB,
-"START_TIME" TIMESTAMP (6),
-"STATUS" VARCHAR2(255),
-"SUSPENDED_TIME" TIMESTAMP (6),
-"TIME_UNIT" VARCHAR2(255),
-"MAT_THROTTLING" NUMBER,
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("JOB_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ORIG_JOB_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-CREATE TABLE "OOZIEDB"."SLA_EVENTS"
- ("EVENT_ID" NUMBER NOT NULL ENABLE,
-"ALERT_CONTACT" VARCHAR2(255),
-"ALERT_FREQUENCY" VARCHAR2(255),
-"ALERT_PERCENTAGE" VARCHAR2(255),
-"APP_NAME" VARCHAR2(255),
-"DEV_CONTACT" VARCHAR2(255),
-"GROUP_NAME" VARCHAR2(255),
-"JOB_DATA" CLOB,
-"NOTIFICATION_MSG" CLOB,
-"PARENT_CLIENT_ID" VARCHAR2(255),
-"PARENT_SLA_ID" VARCHAR2(255),
-"QA_CONTACT" VARCHAR2(255),
-"SE_CONTACT" VARCHAR2(255),
-"SLA_ID" VARCHAR2(255),
-"UPSTREAM_APPS" CLOB,
-"USER_NAME" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"APP_TYPE" VARCHAR2(255),
-"EVENT_TYPE" VARCHAR2(255),
-"EXPECTED_END" TIMESTAMP (6),
-"EXPECTED_START" TIMESTAMP (6),
-"JOB_STATUS" VARCHAR2(255),
-"STATUS_TIMESTAMP" TIMESTAMP (6),
- PRIMARY KEY ("EVENT_ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("JOB_DATA") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("NOTIFICATION_MSG") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("UPSTREAM_APPS") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-CREATE TABLE "OOZIEDB"."WF_ACTIONS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"CONF" CLOB,
-"CONSOLE_URL" VARCHAR2(255),
-"CRED" VARCHAR2(255),
-"DATA" CLOB,
-"ERROR_CODE" VARCHAR2(255),
-"ERROR_MESSAGE" CLOB,
-"EXTERNAL_ID" VARCHAR2(255),
-"EXTERNAL_STATUS" VARCHAR2(255),
-"NAME" VARCHAR2(255),
-"RETRIES" NUMBER,
-"TRACKER_URI" VARCHAR2(255),
-"TRANSITION" VARCHAR2(255),
-"TYPE" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"END_TIME" TIMESTAMP (6),
-"EXECUTION_PATH" VARCHAR2(255),
-"LAST_CHECK_TIME" TIMESTAMP (6),
-"LOG_TOKEN" VARCHAR2(255),
-"PENDING" NUMBER,
-"PENDING_AGE" TIMESTAMP (6),
-"SIGNAL_VALUE" VARCHAR2(255),
-"SLA_XML" CLOB,
-"START_TIME" TIMESTAMP (6),
-"STATUS" VARCHAR2(255),
-"WF_ID" VARCHAR2(255),
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("DATA") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ERROR_MESSAGE") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-CREATE TABLE "OOZIEDB"."WF_JOBS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"APP_NAME" VARCHAR2(255),
-"APP_PATH" VARCHAR2(255),
-"CONF" CLOB,
-"GROUP_NAME" VARCHAR2(255),
-"PARENTID" VARCHAR2(255),
-"RUN" NUMBER,
-"USER_NAME" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"AUTH_TOKEN" CLOB,
-"CREATED_TIME" TIMESTAMP (6),
-"END_TIME" TIMESTAMP (6),
-"EXTERNAL_ID" VARCHAR2(255),
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"LOG_TOKEN" VARCHAR2(255),
-"PROTO_ACTION_CONF" CLOB,
-"SLA_XML" CLOB,
-"START_TIME" TIMESTAMP (6),
-"STATUS" VARCHAR2(255),
-"WF_INSTANCE" BLOB,
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("PROTO_ACTION_CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("WF_INSTANCE") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-CREATE TABLE "OOZIEDB"."OPENJPA_SEQUENCE_TABLE"
- ("ID" NUMBER NOT NULL ENABLE,
-"SEQUENCE_VALUE" NUMBER,
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION DEFERRED
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-TABLESPACE "OOZIEDB";
-
-CREATE TABLE "OOZIEDB"."BUNDLE_JOBS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"APP_NAME" VARCHAR2(255),
-"APP_PATH" VARCHAR2(255),
-"CONF" CLOB,
-"EXTERNAL_ID" VARCHAR2(255),
-"GROUP_NAME" VARCHAR2(255),
-"TIME_OUT" NUMBER,
-"USER_NAME" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"AUTH_TOKEN" CLOB,
-"CREATED_TIME" TIMESTAMP (6),
-"END_TIME" TIMESTAMP (6),
-"JOB_XML" CLOB,
-"KICKOFF_TIME" TIMESTAMP (6),
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"ORIG_JOB_XML" CLOB,
-"PAUSE_TIME" TIMESTAMP (6),
-"PENDING" NUMBER,
-"START_TIME" TIMESTAMP (6),
-"STATUS" VARCHAR2(255),
-"SUSPENDED_TIME" TIMESTAMP (6),
-"TIME_UNIT" VARCHAR2(255),
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("JOB_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ORIG_JOB_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-
-CREATE TABLE "OOZIEDB"."BUNDLE_ACTIONS"
- ("BUNDLE_ACTION_ID" VARCHAR2(255) NOT NULL ENABLE,
-"BUNDLE_ID" VARCHAR2(255),
-"COORD_ID" VARCHAR2(255),
-"COORD_NAME" VARCHAR2(255),
-"CRITICAL" NUMBER,
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"PENDING" NUMBER,
-"STATUS" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
- PRIMARY KEY ("BUNDLE_ACTION_ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB";
-
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/dbscripts-3.0.1.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/dbscripts-3.0.1.sql b/utils/dbutils/updatescripts/dbscripts-3.0.1.sql
deleted file mode 100644
index e0d84b5..0000000
--- a/utils/dbutils/updatescripts/dbscripts-3.0.1.sql
+++ /dev/null
@@ -1,414 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-# please replace "OOZIEDB" to your schema name
-
- CREATE TABLE "OOZIEDB"."COORD_ACTIONS"
- ( "ID" VARCHAR2(255) NOT NULL ENABLE,
- "ACTION_NUMBER" NUMBER,
- "ACTION_XML" CLOB,
- "CONSOLE_URL" VARCHAR2(255),
- "CREATED_CONF" CLOB,
- "ERROR_CODE" VARCHAR2(255),
- "ERROR_MESSAGE" VARCHAR2(255),
- "EXTERNAL_STATUS" VARCHAR2(255),
- "MISSING_DEPENDENCIES" CLOB,
- "RUN_CONF" CLOB,
- "TIME_OUT" NUMBER,
- "TRACKER_URI" VARCHAR2(255),
- "JOB_TYPE" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "CREATED_TIME" TIMESTAMP (6),
- "EXTERNAL_ID" VARCHAR2(255),
- "JOB_ID" VARCHAR2(255),
- "LAST_MODIFIED_TIME" TIMESTAMP (6),
- "NOMINAL_TIME" TIMESTAMP (6),
- "PENDING" NUMBER,
- "RERUN_TIME" TIMESTAMP (6),
- "SLA_XML" CLOB,
- "STATUS" VARCHAR2(255),
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("ACTION_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("CREATED_CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("MISSING_DEPENDENCIES") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("RUN_CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."COORD_JOBS"
- ( "ID" VARCHAR2(255) NOT NULL ENABLE,
- "APP_NAME" VARCHAR2(255),
- "APP_PATH" VARCHAR2(255),
- "BUNDLE_ID" VARCHAR2(255),
- "CONCURRENCY" NUMBER,
- "CONF" CLOB,
- "EXTERNAL_ID" VARCHAR2(255),
- "FREQUENCY" NUMBER,
- "GROUP_NAME" VARCHAR2(255),
- "LAST_ACTION_NUMBER" NUMBER,
- "TIME_OUT" NUMBER,
- "TIME_ZONE" VARCHAR2(255),
- "USER_NAME" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "AUTH_TOKEN" CLOB,
- "CREATED_TIME" TIMESTAMP (6),
- "END_TIME" TIMESTAMP (6),
- "EXECUTION" VARCHAR2(255),
- "JOB_XML" CLOB,
- "LAST_ACTION" TIMESTAMP (6),
- "LAST_MODIFIED_TIME" TIMESTAMP (6),
- "NEXT_MATD_TIME" TIMESTAMP (6),
- "ORIG_JOB_XML" CLOB,
- "PAUSE_TIME" TIMESTAMP (6),
- "PENDING" NUMBER,
- "SLA_XML" CLOB,
- "START_TIME" TIMESTAMP (6),
- "STATUS" VARCHAR2(255),
- "SUSPENDED_TIME" TIMESTAMP (6),
- "TIME_UNIT" VARCHAR2(255),
- "MAT_THROTTLING" NUMBER,
- "DONE_MATERIALIZATION" NUMBER,
- "APP_NAMESPACE" VARCHAR2(255),
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("JOB_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ORIG_JOB_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."SLA_EVENTS"
- ( "EVENT_ID" NUMBER NOT NULL ENABLE,
- "ALERT_CONTACT" VARCHAR2(255),
- "ALERT_FREQUENCY" VARCHAR2(255),
- "ALERT_PERCENTAGE" VARCHAR2(255),
- "APP_NAME" VARCHAR2(255),
- "DEV_CONTACT" VARCHAR2(255),
- "GROUP_NAME" VARCHAR2(255),
- "JOB_DATA" CLOB,
- "NOTIFICATION_MSG" CLOB,
- "PARENT_CLIENT_ID" VARCHAR2(255),
- "PARENT_SLA_ID" VARCHAR2(255),
- "QA_CONTACT" VARCHAR2(255),
- "SE_CONTACT" VARCHAR2(255),
- "SLA_ID" VARCHAR2(255),
- "UPSTREAM_APPS" CLOB,
- "USER_NAME" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "APP_TYPE" VARCHAR2(255),
- "EVENT_TYPE" VARCHAR2(255),
- "EXPECTED_END" TIMESTAMP (6),
- "EXPECTED_START" TIMESTAMP (6),
- "JOB_STATUS" VARCHAR2(255),
- "STATUS_TIMESTAMP" TIMESTAMP (6),
- PRIMARY KEY ("EVENT_ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("JOB_DATA") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("NOTIFICATION_MSG") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("UPSTREAM_APPS") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."WF_ACTIONS"
- ( "ID" VARCHAR2(255) NOT NULL ENABLE,
- "CONF" CLOB,
- "CONSOLE_URL" VARCHAR2(255),
- "CRED" VARCHAR2(255),
- "DATA" CLOB,
- "ERROR_CODE" VARCHAR2(255),
- "ERROR_MESSAGE" CLOB,
- "EXTERNAL_ID" VARCHAR2(255),
- "EXTERNAL_STATUS" VARCHAR2(255),
- "NAME" VARCHAR2(255),
- "RETRIES" NUMBER,
- "TRACKER_URI" VARCHAR2(255),
- "TRANSITION" VARCHAR2(255),
- "TYPE" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "END_TIME" TIMESTAMP (6),
- "EXECUTION_PATH" VARCHAR2(255),
- "LAST_CHECK_TIME" TIMESTAMP (6),
- "LOG_TOKEN" VARCHAR2(255),
- "PENDING" NUMBER,
- "PENDING_AGE" TIMESTAMP (6),
- "SIGNAL_VALUE" VARCHAR2(255),
- "SLA_XML" CLOB,
- "START_TIME" TIMESTAMP (6),
- "STATUS" VARCHAR2(255),
- "WF_ID" VARCHAR2(255),
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("DATA") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ERROR_MESSAGE") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."WF_JOBS"
- ( "ID" VARCHAR2(255) NOT NULL ENABLE,
- "APP_NAME" VARCHAR2(255),
- "APP_PATH" VARCHAR2(255),
- "CONF" CLOB,
- "GROUP_NAME" VARCHAR2(255),
- "PARENTID" VARCHAR2(255),
- "RUN" NUMBER,
- "USER_NAME" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "AUTH_TOKEN" CLOB,
- "CREATED_TIME" TIMESTAMP (6),
- "END_TIME" TIMESTAMP (6),
- "EXTERNAL_ID" VARCHAR2(255),
- "LAST_MODIFIED_TIME" TIMESTAMP (6),
- "LOG_TOKEN" VARCHAR2(255),
- "PROTO_ACTION_CONF" CLOB,
- "SLA_XML" CLOB,
- "START_TIME" TIMESTAMP (6),
- "STATUS" VARCHAR2(255),
- "WF_INSTANCE" BLOB,
- "PARENT_ID" VARCHAR2(255),
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("PROTO_ACTION_CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("WF_INSTANCE") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."BUNDLE_JOBS"
- ( "ID" VARCHAR2(255) NOT NULL ENABLE,
- "APP_NAME" VARCHAR2(255),
- "APP_PATH" VARCHAR2(255),
- "CONF" CLOB,
- "EXTERNAL_ID" VARCHAR2(255),
- "GROUP_NAME" VARCHAR2(255),
- "TIME_OUT" NUMBER,
- "USER_NAME" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "AUTH_TOKEN" CLOB,
- "CREATED_TIME" TIMESTAMP (6),
- "END_TIME" TIMESTAMP (6),
- "JOB_XML" CLOB,
- "KICKOFF_TIME" TIMESTAMP (6),
- "LAST_MODIFIED_TIME" TIMESTAMP (6),
- "ORIG_JOB_XML" CLOB,
- "PAUSE_TIME" TIMESTAMP (6),
- "PENDING" NUMBER,
- "START_TIME" TIMESTAMP (6),
- "STATUS" VARCHAR2(255),
- "SUSPENDED_TIME" TIMESTAMP (6),
- "TIME_UNIT" VARCHAR2(255),
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("JOB_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ORIG_JOB_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."BUNDLE_ACTIONS"
- ( "BUNDLE_ACTION_ID" VARCHAR2(255) NOT NULL ENABLE,
- "BUNDLE_ID" VARCHAR2(255),
- "COORD_ID" VARCHAR2(255),
- "COORD_NAME" VARCHAR2(255),
- "CRITICAL" NUMBER,
- "LAST_MODIFIED_TIME" TIMESTAMP (6),
- "PENDING" NUMBER,
- "STATUS" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- PRIMARY KEY ("BUNDLE_ACTION_ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ;
-
- CREATE TABLE "OOZIEDB"."VALIDATE_CONN"
- ( "ID" NUMBER NOT NULL ENABLE,
- "DUMMY" NUMBER,
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION DEFERRED
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- TABLESPACE "OOZIEDB" ;
-
- CREATE TABLE "OOZIEDB"."OPENJPA_SEQUENCE_TABLE"
- ( "ID" NUMBER NOT NULL ENABLE,
- "SEQUENCE_VALUE" NUMBER,
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION DEFERRED
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- TABLESPACE "OOZIEDB";
-
- CREATE SEQUENCE "OOZIEDB"."EVENT_SEQ"
- MINVALUE 1 MAXVALUE 9999999999999999999999999999
- INCREMENT BY 1 START WITH 351 CACHE 50 NOORDER NOCYCLE;
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/dbscripts-3.1.0.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/dbscripts-3.1.0.sql b/utils/dbutils/updatescripts/dbscripts-3.1.0.sql
deleted file mode 100644
index 5162a8c..0000000
--- a/utils/dbutils/updatescripts/dbscripts-3.1.0.sql
+++ /dev/null
@@ -1,417 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-# please replace "OOZIEDB" to your schema name
-
- CREATE TABLE "OOZIEDB"."COORD_ACTIONS"
- ( "ID" VARCHAR2(255) NOT NULL ENABLE,
- "ACTION_NUMBER" NUMBER,
- "ACTION_XML" CLOB,
- "CONSOLE_URL" VARCHAR2(255),
- "CREATED_CONF" CLOB,
- "ERROR_CODE" VARCHAR2(255),
- "ERROR_MESSAGE" VARCHAR2(255),
- "EXTERNAL_STATUS" VARCHAR2(255),
- "MISSING_DEPENDENCIES" CLOB,
- "RUN_CONF" CLOB,
- "TIME_OUT" NUMBER,
- "TRACKER_URI" VARCHAR2(255),
- "JOB_TYPE" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "CREATED_TIME" TIMESTAMP (6),
- "EXTERNAL_ID" VARCHAR2(255),
- "JOB_ID" VARCHAR2(255),
- "LAST_MODIFIED_TIME" TIMESTAMP (6),
- "NOMINAL_TIME" TIMESTAMP (6),
- "PENDING" NUMBER,
- "RERUN_TIME" TIMESTAMP (6),
- "SLA_XML" CLOB,
- "STATUS" VARCHAR2(255),
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("ACTION_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("CREATED_CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("MISSING_DEPENDENCIES") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("RUN_CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."COORD_JOBS"
- ( "ID" VARCHAR2(255) NOT NULL ENABLE,
- "APP_NAME" VARCHAR2(255),
- "APP_PATH" VARCHAR2(255),
- "BUNDLE_ID" VARCHAR2(255),
- "CONCURRENCY" NUMBER,
- "CONF" CLOB,
- "EXTERNAL_ID" VARCHAR2(255),
- "FREQUENCY" NUMBER,
- "GROUP_NAME" VARCHAR2(255),
- "LAST_ACTION_NUMBER" NUMBER,
- "TIME_OUT" NUMBER,
- "TIME_ZONE" VARCHAR2(255),
- "USER_NAME" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "AUTH_TOKEN" CLOB,
- "CREATED_TIME" TIMESTAMP (6),
- "END_TIME" TIMESTAMP (6),
- "EXECUTION" VARCHAR2(255),
- "JOB_XML" CLOB,
- "LAST_ACTION" TIMESTAMP (6),
- "LAST_MODIFIED_TIME" TIMESTAMP (6),
- "NEXT_MATD_TIME" TIMESTAMP (6),
- "ORIG_JOB_XML" CLOB,
- "PAUSE_TIME" TIMESTAMP (6),
- "PENDING" NUMBER,
- "SLA_XML" CLOB,
- "START_TIME" TIMESTAMP (6),
- "STATUS" VARCHAR2(255),
- "SUSPENDED_TIME" TIMESTAMP (6),
- "TIME_UNIT" VARCHAR2(255),
- "MAT_THROTTLING" NUMBER,
- "DONE_MATERIALIZATION" NUMBER,
- "APP_NAMESPACE" VARCHAR2(255),
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("JOB_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ORIG_JOB_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."SLA_EVENTS"
- ( "EVENT_ID" NUMBER NOT NULL ENABLE,
- "ALERT_CONTACT" VARCHAR2(255),
- "ALERT_FREQUENCY" VARCHAR2(255),
- "ALERT_PERCENTAGE" VARCHAR2(255),
- "APP_NAME" VARCHAR2(255),
- "DEV_CONTACT" VARCHAR2(255),
- "GROUP_NAME" VARCHAR2(255),
- "JOB_DATA" CLOB,
- "NOTIFICATION_MSG" CLOB,
- "PARENT_CLIENT_ID" VARCHAR2(255),
- "PARENT_SLA_ID" VARCHAR2(255),
- "QA_CONTACT" VARCHAR2(255),
- "SE_CONTACT" VARCHAR2(255),
- "SLA_ID" VARCHAR2(255),
- "UPSTREAM_APPS" CLOB,
- "USER_NAME" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "APP_TYPE" VARCHAR2(255),
- "EVENT_TYPE" VARCHAR2(255),
- "EXPECTED_END" TIMESTAMP (6),
- "EXPECTED_START" TIMESTAMP (6),
- "JOB_STATUS" VARCHAR2(255),
- "STATUS_TIMESTAMP" TIMESTAMP (6),
- PRIMARY KEY ("EVENT_ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("JOB_DATA") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("NOTIFICATION_MSG") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("UPSTREAM_APPS") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."WF_ACTIONS"
- ( "ID" VARCHAR2(255) NOT NULL ENABLE,
- "CONF" CLOB,
- "CONSOLE_URL" VARCHAR2(255),
- "CRED" VARCHAR2(255),
- "DATA" CLOB,
- "ERROR_CODE" VARCHAR2(255),
- "ERROR_MESSAGE" CLOB,
- "EXTERNAL_ID" VARCHAR2(255),
- "EXTERNAL_STATUS" VARCHAR2(255),
- "NAME" VARCHAR2(255),
- "RETRIES" NUMBER,
- "TRACKER_URI" VARCHAR2(255),
- "TRANSITION" VARCHAR2(255),
- "TYPE" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "END_TIME" TIMESTAMP (6),
- "EXECUTION_PATH" VARCHAR2(255),
- "LAST_CHECK_TIME" TIMESTAMP (6),
- "LOG_TOKEN" VARCHAR2(255),
- "PENDING" NUMBER,
- "PENDING_AGE" TIMESTAMP (6),
- "SIGNAL_VALUE" VARCHAR2(255),
- "SLA_XML" CLOB,
- "START_TIME" TIMESTAMP (6),
- "STATUS" VARCHAR2(255),
- "WF_ID" VARCHAR2(255),
- "USER_RETRY_COUNT" NUMBER,
- "USER_RETRY_MAX" NUMBER,
- "USER_RETRY_INTERVAL" NUMBER,
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("DATA") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ERROR_MESSAGE") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."WF_JOBS"
- ( "ID" VARCHAR2(255) NOT NULL ENABLE,
- "APP_NAME" VARCHAR2(255),
- "APP_PATH" VARCHAR2(255),
- "CONF" CLOB,
- "GROUP_NAME" VARCHAR2(255),
- "PARENTID" VARCHAR2(255),
- "RUN" NUMBER,
- "USER_NAME" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "AUTH_TOKEN" CLOB,
- "CREATED_TIME" TIMESTAMP (6),
- "END_TIME" TIMESTAMP (6),
- "EXTERNAL_ID" VARCHAR2(255),
- "LAST_MODIFIED_TIME" TIMESTAMP (6),
- "LOG_TOKEN" VARCHAR2(255),
- "PROTO_ACTION_CONF" CLOB,
- "SLA_XML" CLOB,
- "START_TIME" TIMESTAMP (6),
- "STATUS" VARCHAR2(255),
- "WF_INSTANCE" BLOB,
- "PARENT_ID" VARCHAR2(255),
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("PROTO_ACTION_CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("SLA_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("WF_INSTANCE") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."BUNDLE_JOBS"
- ( "ID" VARCHAR2(255) NOT NULL ENABLE,
- "APP_NAME" VARCHAR2(255),
- "APP_PATH" VARCHAR2(255),
- "CONF" CLOB,
- "EXTERNAL_ID" VARCHAR2(255),
- "GROUP_NAME" VARCHAR2(255),
- "TIME_OUT" NUMBER,
- "USER_NAME" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- "AUTH_TOKEN" CLOB,
- "CREATED_TIME" TIMESTAMP (6),
- "END_TIME" TIMESTAMP (6),
- "JOB_XML" CLOB,
- "KICKOFF_TIME" TIMESTAMP (6),
- "LAST_MODIFIED_TIME" TIMESTAMP (6),
- "ORIG_JOB_XML" CLOB,
- "PAUSE_TIME" TIMESTAMP (6),
- "PENDING" NUMBER,
- "START_TIME" TIMESTAMP (6),
- "STATUS" VARCHAR2(255),
- "SUSPENDED_TIME" TIMESTAMP (6),
- "TIME_UNIT" VARCHAR2(255),
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("JOB_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ORIG_JOB_XML") STORE AS BASICFILE (
- TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
- NOCACHE LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
-
- CREATE TABLE "OOZIEDB"."BUNDLE_ACTIONS"
- ( "BUNDLE_ACTION_ID" VARCHAR2(255) NOT NULL ENABLE,
- "BUNDLE_ID" VARCHAR2(255),
- "COORD_ID" VARCHAR2(255),
- "COORD_NAME" VARCHAR2(255),
- "CRITICAL" NUMBER,
- "LAST_MODIFIED_TIME" TIMESTAMP (6),
- "PENDING" NUMBER,
- "STATUS" VARCHAR2(255),
- "BEAN_TYPE" VARCHAR2(31),
- PRIMARY KEY ("BUNDLE_ACTION_ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "OOZIEDB" ;
-
- CREATE TABLE "OOZIEDB"."VALIDATE_CONN"
- ( "ID" NUMBER NOT NULL ENABLE,
- "DUMMY" NUMBER,
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION DEFERRED
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- TABLESPACE "OOZIEDB" ;
-
- CREATE TABLE "OOZIEDB"."OPENJPA_SEQUENCE_TABLE"
- ( "ID" NUMBER NOT NULL ENABLE,
- "SEQUENCE_VALUE" NUMBER,
- PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION DEFERRED
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- TABLESPACE "OOZIEDB";
-
- CREATE SEQUENCE "OOZIEDB"."EVENT_SEQ"
- MINVALUE 1 MAXVALUE 9999999999999999999999999999
- INCREMENT BY 1 START WITH 351 CACHE 50 NOORDER NOCYCLE;
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/readme.txt
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/readme.txt b/utils/dbutils/updatescripts/readme.txt
deleted file mode 100644
index 44840d2..0000000
--- a/utils/dbutils/updatescripts/readme.txt
+++ /dev/null
@@ -1,7 +0,0 @@
-dbscripts-3.0.0.sql will be used to create all the tables if we have new schema.
-
-updatescripts-2.x-to-3.0.0.sql will be used to update the tables from 2.x to 3.0.0.
-
-upgradescript-2.x-to-3.0.0.sql will be used to change the previous statuses to new statuses when we will update the current running system of 2.x to 3.0.0
-
-For all the scripts please change the db name and run the script.
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.0.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.0.sql b/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.0.sql
deleted file mode 100644
index 9c8a06c..0000000
--- a/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.0.sql
+++ /dev/null
@@ -1,101 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-ALTER TABLE COORD_ACTIONS ADD PENDING NUMBER DEFAULT 0;
-ALTER TABLE COORD_JOBS ADD PENDING NUMBER DEFAULT 0;
-ALTER TABLE COORD_JOBS ADD MAT_THROTTLING NUMBER DEFAULT 12;
-ALTER TABLE WF_JOBS ADD PARENTID VARCHAR2(255);
-
-# please replace "OOZIEDB" to your schema name
-
-CREATE TABLE "OOZIEDB"."BUNDLE_JOBS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"APP_NAME" VARCHAR2(255),
-"APP_PATH" VARCHAR2(255),
-"CONF" CLOB,
-"EXTERNAL_ID" VARCHAR2(255),
-"GROUP_NAME" VARCHAR2(255),
-"TIME_OUT" NUMBER,
-"USER_NAME" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"AUTH_TOKEN" CLOB,
-"CREATED_TIME" TIMESTAMP (6),
-"END_TIME" TIMESTAMP (6),
-"JOB_XML" CLOB,
-"KICKOFF_TIME" TIMESTAMP (6),
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"ORIG_JOB_XML" CLOB,
-"PAUSE_TIME" TIMESTAMP (6),
-"PENDING" NUMBER,
-"START_TIME" TIMESTAMP (6),
-"STATUS" VARCHAR2(255),
-"SUSPENDED_TIME" TIMESTAMP (6),
-"TIME_UNIT" VARCHAR2(255),
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("JOB_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ORIG_JOB_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-
-CREATE TABLE "OOZIEDB"."BUNDLE_ACTIONS"
- ("BUNDLE_ACTION_ID" VARCHAR2(255) NOT NULL ENABLE,
-"BUNDLE_ID" VARCHAR2(255),
-"COORD_ID" VARCHAR2(255),
-"COORD_NAME" VARCHAR2(255),
-"CRITICAL" NUMBER,
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"PENDING" NUMBER,
-"STATUS" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
- PRIMARY KEY ("BUNDLE_ACTION_ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB";
-
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.1.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.1.sql b/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.1.sql
deleted file mode 100644
index 3620e07..0000000
--- a/utils/dbutils/updatescripts/updatescripts-2.x-to-3.0.1.sql
+++ /dev/null
@@ -1,104 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-ALTER TABLE WF_JOBS ADD PARENT_ID VARCHAR2(255);
-ALTER TABLE WF_ACTIONS MODIFY EXECUTION_PATH VARCHAR2(1024);
-ALTER TABLE COORD_JOBS ADD PENDING NUMBER DEFAULT 0;
-ALTER TABLE COORD_JOBS ADD MAT_THROTTLING NUMBER DEFAULT 12;
-ALTER TABLE COORD_JOBS ADD DONE_MATERIALIZATION NUMBER DEFAULT 0;
-ALTER TABLE COORD_JOBS ADD APP_NAMESPACE VARCHAR2(255) DEFAULT 'uri:oozie:coordinator:0.1';
-ALTER TABLE COORD_ACTIONS ADD PENDING NUMBER DEFAULT 0;
-
-# please replace "OOZIEDB" to your schema name
-
-CREATE TABLE "OOZIEDB"."BUNDLE_JOBS"
- ("ID" VARCHAR2(255) NOT NULL ENABLE,
-"APP_NAME" VARCHAR2(255),
-"APP_PATH" VARCHAR2(255),
-"CONF" CLOB,
-"EXTERNAL_ID" VARCHAR2(255),
-"GROUP_NAME" VARCHAR2(255),
-"TIME_OUT" NUMBER,
-"USER_NAME" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
-"AUTH_TOKEN" CLOB,
-"CREATED_TIME" TIMESTAMP (6),
-"END_TIME" TIMESTAMP (6),
-"JOB_XML" CLOB,
-"KICKOFF_TIME" TIMESTAMP (6),
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"ORIG_JOB_XML" CLOB,
-"PAUSE_TIME" TIMESTAMP (6),
-"PENDING" NUMBER,
-"START_TIME" TIMESTAMP (6),
-"STATUS" VARCHAR2(255),
-"SUSPENDED_TIME" TIMESTAMP (6),
-"TIME_UNIT" VARCHAR2(255),
- PRIMARY KEY ("ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB"
- LOB ("CONF") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("AUTH_TOKEN") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("JOB_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
- LOB ("ORIG_JOB_XML") STORE AS BASICFILE (
-TABLESPACE "OOZIEDB" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
-NOCACHE LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT));
-
-
-CREATE TABLE "OOZIEDB"."BUNDLE_ACTIONS"
- ("BUNDLE_ACTION_ID" VARCHAR2(255) NOT NULL ENABLE,
-"BUNDLE_ID" VARCHAR2(255),
-"COORD_ID" VARCHAR2(255),
-"COORD_NAME" VARCHAR2(255),
-"CRITICAL" NUMBER,
-"LAST_MODIFIED_TIME" TIMESTAMP (6),
-"PENDING" NUMBER,
-"STATUS" VARCHAR2(255),
-"BEAN_TYPE" VARCHAR2(31),
- PRIMARY KEY ("BUNDLE_ACTION_ID")
-USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB" ENABLE
- ) SEGMENT CREATION IMMEDIATE
-PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-TABLESPACE "OOZIEDB";
-
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/updatescripts-3.0.0-to-3.0.1.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/updatescripts-3.0.0-to-3.0.1.sql b/utils/dbutils/updatescripts/updatescripts-3.0.0-to-3.0.1.sql
deleted file mode 100644
index 6a6a4fc..0000000
--- a/utils/dbutils/updatescripts/updatescripts-3.0.0-to-3.0.1.sql
+++ /dev/null
@@ -1,23 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-ALTER TABLE WF_JOBS DROP PARENTID;
-ALTER TABLE WF_JOBS ADD PARENT_ID VARCHAR2(255);
-ALTER TABLE WF_ACTIONS MODIFY EXECUTION_PATH VARCHAR2(1024);
-ALTER TABLE COORD_JOBS ADD DONE_MATERIALIZATION NUMBER DEFAULT 0;
-ALTER TABLE COORD_JOBS ADD APP_NAMESPACE VARCHAR2(255);
\ No newline at end of file