SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

No rows inserted

663318Mar 9 2009 — edited Mar 10 2009

Hi all,

When i run my SELECT query ( SELECT <my_fields> FROM <my_table> ) , i have 59332 rows returned.

Unfortunately, when i want to insert these rows into another empty table(INSERT INTO another_table SELECT <my_fields> FROM <my_table> ),
this table stays empty (0 rows inserted).

The two tables share the same structure. The SELECT query is strictly the same in the two cases.
I'm using Oracle 10gR2 32-bits on Linux.

Any idea ?
Stephan

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2009

Added on Mar 9 2009

20 comments

1,057 views