Oracle DBA Studio - Table Wizard

From: Luke <anduguid_at_home.com>
Subject: Oracle DBA Studio - Table Wizard Date: Wednesday, February 14, 2001 8:04 PM

hi there,

just coming to grips with Personal Oracle8i (free download version)

have been using the Oracle DBA Studio to create tables, when using table wizard it generates the SQL but the constraints has a double quote with nothing in it, which of course generates a :

ORA-01741: illegal zero-length identifier

an eg.

CREATE TABLE "LUKE"."COOKBOOKTB"("ID" NUMBER(11) NOT NULL,
"USER_RECIPE_NAME" VARCHAR2(60), "RECIPE_CATEGORY_ID" NUMBER(11),
"INGREDIENTS" VARCHAR2(2000), "PREPERATION" VARCHAR2(2000), "NOTES"
VARCHAR2(2000), UNIQUE(ID), CONSTRAINT "" PRIMARY KEY("ID"), FOREIGN KEY("RECIPE_CATEGORY_ID") REFERENCES "LUKE"."CATEGORYTB"("CATEGORY_ID")) TABLESPACE "COOKBOOK" notice the CONSTRIANT ""

now i solve this by using the wizard to generate the above then cut & paste into the Oracle SQL*Plus window and manually add a space eg.

CONSTRIANT " " this is a pain to say the least... is there a patch/fix to get the wizard to generate 'correct' SQL ?

or better yet:
from what i have expericenced the DBA Studio is not really appropiate @ what i think is more of a 'developer level' features, such as table populating etc. , are there some more freeware tools out there to make this job easier?

luke duguid Received on Wed Feb 14 2001 - 23:46:03 CST