Grant Read is currently ignored as it is not supported in Oracle 11g.
Transformations can be created, but not altered at this time.Queue Publishers are not supported
Ordering issue
Partial Deploy Grants - testing on fdglp01 now, but looks like it is working
Grants to objects other than Tables - should test them as well.
Invalid Types are not baselined.
FDDB DDL Changes for Queue support is added in this release:
CREATE TABLE FDDB.FD_QUEUES
( SCHEMA_VERSION NUMBER(20,0) NOT NULL ENABLE,
OWNER VARCHAR2(128) NOT NULL ENABLE,
NAME VARCHAR2(128) NOT NULL ENABLE,
QUEUE_TABLE VARCHAR2(128) NOT NULL ENABLE,
QID NUMBER NOT NULL ,
QUEUE_TYPE VARCHAR2(20) ,
MAX_RETRIES NUMBER ,
RETRY_DELAY NUMBER ,
ENQUEUE_ENABLED VARCHAR2(7) ,
DEQUEUE_ENABLED VARCHAR2(7) ,
RETENTION VARCHAR2(40) ,
USER_COMMENT VARCHAR2(50) ,
NETWORK_NAME VARCHAR2(512),
CONSTRAINT FD_DB_QUEUES_PK PRIMARY KEY (SCHEMA_VERSION, OWNER, NAME));
/
CREATE TABLE FDDB.FD_QUEUE_TABLES
( SCHEMA_VERSION NUMBER(20,0) NOT NULL ENABLE,
OWNER VARCHAR2(128) ,
QUEUE_TABLE VARCHAR2(128) ,
TYPE VARCHAR2(7) ,
OBJECT_TYPE VARCHAR2(257) ,
SORT_ORDER VARCHAR2(22) ,
RECIPIENTS VARCHAR2(8) ,
MESSAGE_GROUPING VARCHAR2(13) ,
COMPATIBLE VARCHAR2(6) ,
PRIMARY_INSTANCE NUMBER ,
SECONDARY_INSTANCE NUMBER ,
OWNER_INSTANCE NUMBER ,
USER_COMMENT VARCHAR2(50),
SECURE VARCHAR2(3) ,
CONSTRAINT FD_DB_QUEUE_TBL_PK PRIMARY KEY (SCHEMA_VERSION, OWNER, QUEUE_TABLE));
/
CREATE TABLE FDDB.FD_QUEUE_SCHEDULES
( SCHEMA_VERSION NUMBER(20,0) NOT NULL ENABLE,
SCHEMA VARCHAR2(128) ,
QNAME VARCHAR2(128) ,
DESTINATION VARCHAR2(128) ,
START_DATE TIMESTAMP(6) WITH TIME ZONE ,
START_TIME VARCHAR2(8) ,
PROPAGATION_WINDOW NUMBER ,
NEXT_TIME VARCHAR2(4000) ,
LATENCY NUMBER ,
SCHEDULE_DISABLED VARCHAR2(1) ,
MESSAGE_DELIVERY_MODE VARCHAR2(10) ,
JOB_NAME VARCHAR2(128)
CONSTRAINT FD_DB_QUEUE_SCH_PK PRIMARY KEY (SCHEMA_VERSION, OWNER, QNAME, DESTINATION));
/
CREATE TABLE FDDB.FD_QUEUE_PUBLISHERS
( SCHEMA_VERSION NUMBER(20,0) NOT NULL ENABLE,
QUEUE_OWNER VARCHAR2(128) NOT NULL ENABLE,
QUEUE_NAME VARCHAR2(128) NOT NULL ENABLE,
PUBLISHER_NAME VARCHAR2(128) ,
PUBLISHER_ADDRESS VARCHAR2(1024) ,
PUBLISHER_PROTOCOL NUMBER ,
PUBLISHER_RULE VARCHAR2(2000) ,
PUBLISHER_RULE_NAME VARCHAR2(257) ,
PUBLISHER_RULESET VARCHAR2(257) ,
PUBLISHER_TRANSFORMATION VARCHAR2(257) ,
CONSTRAINT FD_DB_QUEUE_PUB_PK PRIMARY KEY (SCHEMA_VERSION, QUEUE_OWNER, QUEUE_NAME));
/
CREATE TABLE FDDB.FD_QUEUE_SUBSCRIBERS
( SCHEMA_VERSION NUMBER(20,0) NOT NULL ENABLE,
OWNER VARCHAR2(30) NOT NULL ENABLE ,
QUEUE_NAME VARCHAR2(128) NOT NULL ENABLE ,
QUEUE_TABLE VARCHAR2(128) NOT NULL ENABLE ,
CONSUMER_NAME VARCHAR2(30) ,
ADDRESS VARCHAR2(1024) ,
PROTOCOL NUMBER ,
TRANSFORMATION VARCHAR2(61) ,
RULE CLOB ,
DELIVERY_MODE VARCHAR2(22) ,
IF_NONDURABLE_SUBSCRIBER VARCHAR2(3) ,
QUEUE_TO_QUEUE VARCHAR2(5) ,
CONSTRAINT FD_DB_QUEUE_SUB_PK PRIMARY KEY (SCHEMA_VERSION, OWNER, QUEUE_NAME, QUEUE_TABLE));
/
CREATE TABLE FDDB.FD_TRANSFORMATIONS
( SCHEMA_VERSION NUMBER(20,0) NOT NULL ENABLE,
OWNER VARCHAR2(30) NOT NULL ENABLE ,
NAME VARCHAR2(30) NOT NULL ENABLE ,
FROM_TYPE VARCHAR2(61),
TO_TYPE VARCHAR2(61),
CONSTRAINT FD_DB_transform_PK PRIMARY KEY (SCHEMA_VERSION, OWNER, NAME));
ALTER TABLE FDDB.FD_TAB_PRIVS ADD (OBJECT_TYPE VARCHAR2(30) DEFAULT 'TABLE' );
ALTER TABLE FDDB.FD_TAB_PRIVS RENAME COLUMN TABLE_NAME TO OBJECT_NAME;. Queues bring their Queue Tables, Schedules, Subscribers, and grants with them.
Queue Publishers are not supported.
Queue Agents are not supported.
Grants to objects that are renamed?
Remove Job support?
Job schedule and Job Program support is added in this release. Select the Job object type to build and deploy them.
Actual Jobs are not supported.
Transformations - These are counted as queues currently. Probably should add a new output for them.
All customers will drop fddb schema and recreate it. All prior builds will be in an unusable state, and shouldn't be reused.