Re: Designer db generation: Bug or PEBKAC

Mike,

I can only confirm my experience with generating DLL is the same as yours. Only when you assign a table to a user, designer will generate a storage clausule and tablespace names with the table or index. Designer is nerve wrecking.. Try to generate a complex form-layout just the way you want it for a change....

Arjen Huisman

Mike Dwyer wrote:

> (PEBKAC: Problem exists between keyboard and chair). Is this a problem with
> Designer, or am I doing something wrong?
>
> I am in the Design Editor, regenerating indexes (indices for purists) for an
> existing table. In the DB Admin navigator, I have specified a tablespace for
> the index, under User Object Index Storage. The generated DDL uses this
> spec. All is good.
>
> But then, I return to the Server Model navigator to change an index to
> Bitmap, and regenerate the DDL (after dropping the "normal" index in TOAD).
> This DDL does NOT use the specified tablespace! Turns out I have to return
> to the DB Admin tab and navigate at least as far as the Users node (there is
> only 1 user listed) for the DDL to use the tablespace specification. (I
> notice that the Objects tab on the Generate Database from Server Model
> dialog also changes from User Selection to dbname.username at the top node.)
>
> Is this intentional behavior for Designer? I suppose it is, but since I am
> learning Designer on the fly I find it nerve-wracking. Thoughts on the
> subject are appreciated. Thanks.
  Received on Fri Oct 27 2000 - 22:04:35 CEST