Re: Bug 3798351 Importing a pre-existing table may DROP the table on an error
Date: Tue, 22 Jun 2010 21:17:22 -0700 (PDT)
Message-ID: <389707.80055.qm_at_web113215.mail.gq1.yahoo.com>
Sorry.... bug number is on the subject line.... long day, tired eyes!! :)
RF
Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.
Blog: http://robertgfreeman.blogspot.com
From: Robert Freeman <robertgfreeman_at_yahoo.com> To: exriscer_at_gmail.com; Oracle Mailinglist <oracle-l_at_freelists.org> Sent: Tue, June 22, 2010 9:10:11 PM
Subject: Re: Bug 3798351 Importing a pre-existing table may DROP the table on an error
Am I getting this right... an import failed, raised an error, and then as a result of the error the import program dropped a table? Do you have a bug number for this?
RF
Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.
Blog: http://robertgfreeman.blogspot.com
From: LS Cheng <exriscer_at_gmail.com>
To: Oracle Mailinglist <oracle-l_at_freelists.org> Sent: Tue, June 22, 2010 3:17:04 PM
Subject: Bug 3798351 Importing a pre-existing table may DROP the table on an error
Hi
I have a customer hit this nasty bug this morning.
Really really nasty which affects 9.2.0.5 and 9.2.0.6. It turns out customer was trying to import a few thousands rows to the applicacion main table (partitioned), composed by 800 million rows, the first import gave an error complaining buffer size too small and that triggered a DROP TABLE which was lighting fast by the way, dropping the table and all partitions took around 15 seconds, we suspect that it didnt even try to drop the table physically, just updated data dictionary.
So what a disgrace my customer said, Oracle Software actually deleted his most important database table and the doubt is what is Oracle responsability in this situation? The system has been stopped 10 hours already due to this bug (database is around 2TB and requires complete restore).
TIA
--
LSC
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 22 2010 - 23:17:22 CDT