SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Schema Extraction with DBTools 3.00.05

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Schema Extraction with DBTools 3.00.05
Author Message
Walter Conrads



Joined: 16 Jan 2000
Posts: 1

Post Schema Extraction with DBTools 3.00.05 Reply with quote

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

Tue Jul 25, 2000 7:18 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Re: Schema Extraction with DBTools 3.00.05 Reply with quote

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

Sat Sep 16, 2000 6:17 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.