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

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