Click to See Complete Forum and Search --> : To Copy records from table1 to table2


sqlcrazy
02-14-2008, 09:37 AM
I have two tables TABLE1 and TABLE2 with same structures. I want to copy records from TABLE2 to TABLE1.

I executed the following query:
insert into TABLE1 select * from TABLE2;

But i got the following error:
ORA-00600: internal error code, arguments: [kdtigetrow-2], [0], [288], [523],[], [], [], []

Can anyone help me solve this error?

chazzy
02-14-2008, 11:49 AM
http://www.dbmotive.com/oracle_error_codes.php?errcode=00600

Apparently, it represents a bug in oracle.

sqlcrazy
02-14-2008, 10:33 PM
Thanks chazzy...:)