Re: Oracle Designer R 6.0
From: Surfnet <j.r.l.m.bataille#3#_at_uva.nl>
Date: Fri, 19 Apr 2002 23:18:39 +0200
Message-ID: <a9q276$bmi$1_at_news.surfnet.nl>
Date: Fri, 19 Apr 2002 23:18:39 +0200
Message-ID: <a9q276$bmi$1_at_news.surfnet.nl>
Hello Ralph,
[Quoted] I presume you generate the scripts in the Design Editor, while viewing the
server model. If you change your view to the DB admin tab, find your
database, user, schema, tables (I'm not at work at the moment so I might be
missing a node...) and then generate, the storage parameters should be
there.
Does this help?
Regards, Joost
-- Joost Bataille University of Amsterdam ICT centre www.ic.uva.nl Ralph" <crrs_at_airtel.net> wrote in message news:85d0ec10.0204180824.6c5b41bf_at_posting.google.com...Received on Fri Apr 19 2002 - 23:18:39 CEST
> I am trying to generate de DDL files. I get all the script files but
> with the exception of the storage information and pctfree, pctused,
> tablespace in the script to create the tables.
>
> For example, this is what I get:
>
> -- c:\abc\def\oraddl.tab
> --
> -- Generated for Oracle 8 on Thu Apr 18 17:47:20 2002 by Server
> Generator 6.0.3.9.0
>
> PROMPT Creating Table 'TX'
> CREATE TABLE TX
> (C VARCHAR2(1) NOT NULL
> ,DESCRIP VARCHAR2(30)
> )
> /
>
> I have defined the different storage in the Repository, each table is
> assigned to the appropiate storage, the storage have assigned the
> tablespace, Complete ? is set to yes, etc.,etc.
>
> I think I am missing to check (don't know where) that I want to
> include the storage parameters during generation.
>
> Any idea? Thanks for any help.