| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ALTER TABLE MOVE LOB ... Watch Out !!!!
I can wholeheartedly sympathize.
Taking advantage of the slow work period, I patched an SAP database from 8.0.4.0 to 8.0.4.4 and rendered SAP totally unusable.
This was not what I wanted at 1:30 a.m.
I left it til the morrow and finally tracked it down to the patch changing
the
NLS_LANG registry entry to an apparently random value. It appears that
that installer played lanquage roulette with my database.
Only on NT...
Jared
"MacGregor,
Ian A." To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
<ian_at_SLAC.Stan cc:
ford.EDU> Subject: ALTER TABLE MOVE LOB ... Watch
Out !!!!
Sent by:
root_at_fatcity.c
om
01/04/02 08:55
AM
Please respond
to ORACLE-L
Over the holidays, as is the wont of many a DBA, I was doing some work
while the databases were relatively quiet. One thing I did was to move a
lob segment to another tablespace. The lob segment contains employee
pictures for our online phonebook. After the move I looked at 50 of the
pictures and they all properly displayed. "Humph!", I thought, what this
about a problem with moving lob's. The move was done on the afternoon of
New Year's Eve. The next day, I got a frantic
phone call. Selects against the table such as "select distinct modified
by from ..." were returning the value 'Y' instead of the key of the person
modifying the record, other fields were equally messed up. When I tried to
look at a date field,
It squawked about format problems. Things were very much hosed. It was as
if the logical table did not map properly to its physical counterpart.
Interestingly the 7 records added since the lob was moved were all okay.
I was able to recover from this disaster. I had exported the table before
the move. I moved the 7 "good" rows
to another table. Truncated the corrupted one, performed the import, and
moved the 7 good records back in.
I had never seen Oracle corrupt a table so, and hope to never again!!
Ian MacGregor
Stanford Linear Acclerator Center
ian_at_slac.stanford.edu
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: ian_at_SLAC.Stanford.EDU Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Jan 04 2002 - 13:05:10 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |