Re: Generate sql file from Oracle Designer

procman wrote:
> I'm using Oracle Designer to design and maintenance the DB on PC.
> The "real" schema is on the Unix.
> In order to add a new table or edit an exist table, i'm doing the
> following:
> 1. edit a table in the designer.
> 2. generate *.tab, *.con and *.sql files from the designer (on the
> PC).
> 3. Run an internal generator(on the Unix) to generate interface for my
> application, from the *.sql file.
>
> My question is:
> How can I generate *.sql file (with the *.tab/*.con files) from a
> table, and not direct from the designer. I mean, is there any
> interface or API to do that? is there any stand alone executable to
> generate sql file NOT from Oracle Designer?
> I need it to combine steps 2&3 above to single step (wrap them in one
> exe or script).
>
>
> Thanks
Is there some reason you can't directly generate to the unix instance. When you generate to an instance Designer looks at the instance and figures out what to write in its script. That is, you can generate to development and it will do alter table add ... s for you, then generate to prod later and it will do the appropriate alter table add... s even though the columns already exist in development. Received on Thu Feb 10 2005 - 21:52:52 CET