TOAD for Oracle: Copy new columns from one schema to another?
Date: 29 Nov 2006 13:55:15 -0800
Message-ID: <1164837315.249180.303760_at_80g2000cwy.googlegroups.com>
[Quoted] [Quoted] 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.
[Quoted] 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?
[Quoted] 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 Received on Wed Nov 29 2006 - 22:55:15 CET