Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle DBA Studio - TAble Wizard
You can find out if there's a patch by going to Oracle's technical site(s). But there's quite a few things that DBA Studio cannot do when it comes to table creation. Compare the options open to you from the Oracle documentation for CREATE TABLE... with the options open to you in DBA Studio. So - many times you're going to be using a script anyway. And that's not necessarily a bad thing. Scripts are compact, reusable and very portable - even to machines that cannot be reached by DBA Studio.
Van
"Luke" <anduguid_at_home.com> wrote in message
news:AFBi6.96048$t94.1306716_at_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 Sat Feb 17 2001 - 20:56:55 CST