Oracle DBA Studio - TAble Wizard

From: Luke <anduguid_at_home.com>
Date: Wed, 14 Feb 2001 20:13:20 GMT
Message-ID: <AFBi6.96048$t94.1306716@news1.rdc1.bc.home.com>

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 ""

nowi 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 ?

luke duguid Received on Wed Feb 14 2001 - 14:13:20 CST