Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Copying rows without naming columns
Hi!
Maybe you can generate your sql using lookup in the dictionary view
all_tables.
/Bjørn
"Tarby777" <nick_williamson_at_mentorg.com> skrev i en meddelelse
news:1128526226.780825.267050_at_g47g2000cwa.googlegroups.com...
> 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 - 13:53:57 CDT