insert into ORA-00001 unique constraint on rowid

Hi.

We have this table that has a key call id_row where apparently, rowid is inserted.

I'm trying to insert into that table from another table.

What's the best way to get and insert the unique rowid?

my insert looks like this

insert into tab1 g (g.x,g.y,g.z,g.id_row) select b.x,b.y,b.z,b.id_row from tab2 b where not exists (
  select x from tab1 a where a.x=b.x)

I guess I'm not sure, how do pass rowid of g into to g.id_row???

Thanks for any help or information. Received on Tue Oct 02 2007 - 19:47:10 CDT