All these issues have been fixed. Please check out DB Tools v3.2 beta : We have downloaded the trialversion of DBTools. This Utility will be very : helpfull for us if the following Bugs in the Schema Extraction will be : corrected: 1. If no size is specified for the cluster the create Cluster : Statement contains a line like : SIZE K : This will create an error. : 2. If a table is part of a cluster the pctfree, pctused, initrans and : maxtrans values are 0. : If the create table statement contains the parameters : INITRANS 0, : MAXTRANS 0, : PCTFREE 0, : PCTUSED 0 : a error will created. : If a table is part of a cluster no such values are allowed. : 3. If a not null column of a table has a defaultvalue, DBTools will write for : example: curr_id VARCHAR2(3) NOT NULL DEFAULT 'USD', : The correct sysntax is : curr_id VARCHAR2(3) DEFAULT 'USD' NOT NULL, : 4. Sometimes DBTools writes a line like : ALTER TABLE mm1.test ADD CONSTRAINT CHECK sys_c006590 (TR_POSART IN (' : ','PA','PK','PN','PT','PZ') ) ; : or : ALTER TABLE mm1.mm_test ADD CONSTRAINT PRIMARY KEY mm_test_pk ( : The correct Syntax is : ALTER TABLE mm1.test ADD CONSTRAINT sys_c006590 CHECK (TR_POSART IN (' : ','PA','PK','PN','PT','PZ') ) ; : or : ALTER TABLE mm1.mm_test ADD CONSTRAINT mm_test_pk PRIMARY KEY ( : 5. DBTools is using a wrong sysntax for Primary Keys with index. DBTools : writes : ALTER TABLE mm1.mm_test ADD CONSTRAINT mm_test_pk PRIMARY KEY ( : SEQUENCE, : YEAR, : MONTH, : SUPPL_NO, : ART_NO ) : USING INDEX STORAGE ( : TABLESPACE MMSIDX : PCTFREE 5 : INITRANS 4 : MAXTRANS 255 : STORAGE (INITIAL 8K : NEXT 4K : MINEXTENTS 1 : MAXEXTENTS 249 : PCTINCREASE 50 : FREELISTS 1 : FREELIST GROUPS 1) ) ; : The correct syntax is : ALTER TABLE mm1.mm_test ADD CONSTRAINT mm_test_pk PRIMARY KEY ( : SEQUENCE, : YEAR, : MONTH, : SUPPL_NO, : ART_NO ) : USING INDEX : TABLESPACE MMSIDX : PCTFREE 5 : INITRANS 4 : MAXTRANS 255 : STORAGE (INITIAL 8K : NEXT 4K : MINEXTENTS 1 : MAXEXTENTS 249 : PCTINCREASE 50 : FREELISTS 1 : FREELIST GROUPS 1) ; : 6. Sometimes it hapens that DBTools is cutting the column name of the first : column in an Alter Table Statement which adds a primary key. It seems that : the max length of the first two lines is limited to 115. : For Example: ALTER TABLE mm1.mm_service_contracts ADD CONSTRAINT PRIMARY KEY : mm_service_contracts_pk_prim ( : mm_service_c, : mm_firm_id ) DISABLE ; : The correct alter table statement would be: ALTER TABLE : mm1.mm_service_contracts ADD CONSTRAINT mm_service_contracts_pk_prim : PRIMARY KEY ( : mm_service_contract_id, : mm_firm_id ) DISABLE ; : REMARK This example contains also the Error of point 4, but this is not the : reason, because it happens also if the error 4 is not present. : Kindly regards : Walter Conrads
|