Skip to Main Content

Oracle Database Discussions

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!

Delete using trunc(sysdate-1,'mon')

592323Aug 15 2007 — edited Aug 15 2007
Hi 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2007
Added on Aug 15 2007
1 comment
400 views