Re: TOAD for Oracle: Copy new columns from one schema to another?

From: sybrandb <sybrandb_at_gmail.com>
Date: 30 Nov 2006 06:57:46 -0800
Message-ID: <1164898666.795499.172820_at_80g2000cwy.googlegroups.com>


[Quoted] Actually, 9.0 just hit the market.

I'm running 8.6.0.36, with several options, among them the DBA option.

When I click DBA, the second lowest line shows 'Compare schemas' I can select which object types to compare, and I can provide a script filename.
This results in a series of ALTER statements.

I really don't know when this was introduced, and/or in which modules, sorry.

--
Sybrand Bakker
Senior Oracle DBA


On Nov 30, 3:03 pm, "Kevin Blount" <kevin.blo..._at_gmail.com> wrote:

> I have found the "compare schemas" feature (it's the "Compare with
> another object" feature, right?) and saw the differences, but could not
> see any way to generate the code you mentioned.
>
> Looking at the "File Difference" screen, I see all the differences
> (naturally) but I don't see any icons above for generating the code.
> COuld you tell me what to look for?
>
> I'm sure it might make the difference, but my company is running Toad
> for Oracle 8.5 - are there newer versions?
>
> Many thanks
>
> Kevin
>
>
>
> sybrandb wrote:
> > Kevin Blount wrote:
> > > I have two schema that I use: one for development and one that's used
> > > for live data.
>
> > > I'm currently working on a large project so I have extensive updates to
> > > the development schema and various databases within it. In most cases
> > > this is just the addition of new columns to an existing table, but in
> > > other cases it's a whole new table.
>
> > > I can handle adding the complete new tables (right-click: Create in
> > > another schema) but I can't find a way to add selected columns from one
> > > schema to another.
>
> > > e.g. I have a common table (between dev and live) with 30 columns. I
> > > added another 5 to the dev table, and need now to get those 5 to the
> > > live table. In some cases there are less than 5, but there are also
> > > cases where there are more, sometimes a lot more.
>
> > > Is there a Toad for Oracle function that will allow me to select the
> > > new columns in my dev table, and copy them to the live table?
>
> > > If not, would someone be able to advise me on any SQL statements I
> > > might use, or do I have to do this manually?
>
> > > TIA
>
> > > Kevin
>
> > The full version of Toad can *compare schemas* and generate code to
> > rectify it in one direction.
> > Note: the free version can not do this.
> > You can obviously do this yourself by querying the dictionary.
> > It is not that difficult.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA- Hide quoted text -- Show quoted text -
Received on Thu Nov 30 2006 - 15:57:46 CET

Original text of this message