Grant Read is currently ignored as it is not supported in Oracle 11g.
Transformations can be created, but not altered at this timeColumn object grants or not baselined or deployed
Invalid Types are not baselined.
Queues bring their Queue Tables, Schedules, Subscribers, and grants with them.
Queue Publishers are not supported.
Invalid Types Queue Agents are not baselinedsupported.
FDDB DDL Changes for 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;Object Tables are not supported at this time (example of this DDL: CREATE TABLE SCHEMA_NAME.TABLE_NAME OF SCHEMA_NAME.USER_DEFINED_TYPE ( CONSTRAINT PK_TABLENAME PRIMARY KEY (name)) OBJECT IDENTIFIER IS PRIMARY KEY;
It is necessary to drop the fddb schema and recreate it to upgrade from the 4.5 version. This is not necessary migrating from the 5.0 version or later. All prior builds will be in an unusable state, and shouldn't be reused.