Copying rows without naming columns

Hi all,

I have a 9i database with two schemas that each contain a set of tables having the same names, and similar but not identical columns. I want to copy table contents from one schema to the other. The tables in the target schema may have a different column order, they might have new columns, they might be missing some of the columns from the equivalent table in the source schema.

Of course, I could "insert into b.table (col1,col2,col3) select col1,col2,col3 from a.table" but I have to do this for over twenty tables and they have many more columns than that example. What I'm hoping is that there's a command in 9i that says "don't worry about mismatches, just copy between identically-named columns" - is there such a thing?

TIA
Nick Received on Wed Oct 05 2005 - 10:30:26 CDT