Delete using trunc(sysdate-1,'mon')
592323Aug 15 2007 — edited Aug 15 2007Hi all,
I am deleting the records in a table by the command
delete from tablename where create_dt >= trunc(sysdate-1,'mon');
Now i want to insert the records by
insert into tablename select * from tablename@databaselink where create_dt >= trunc(sysdate-1,'mon');
But this statemnt gives me an error
ORA ERROR at line 1:
ORA-03113: end-of-file on communication channel
When i looked the alert log file i came to know this
INSERT INTO tablename SELECT * FROM tablename WHERE CREATE_DT >= trunc(sysdate-1,'MON')
*
i looked at the alert log file and i can see the error message
Errors in file /opt/app/oracle/admin/erprod/udump/erprod_ora_4429.trc:
ORA-00600: internal error code, arguments: [qerrmObnd1], [932], [ORA-00932: inconsistent datatypes: expected got
], [], [], [], [], []
Wed Aug 15 14:59:16 2007
Errors in file /opt/app/oracle/admin/erprod/udump/erprod_ora_4429.trc:
ORA-07445: exception encountered: core dump [qerrmOdcl()+32] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
ORA-00600: internal error code, arguments: [qerrmObnd1], [932], [ORA-00932: inconsistent datatypes: expected got
Can anyone help me regarding this?