| BLOB are missing [message #548410] |
Thu, 22 March 2012 01:27  |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
hi,
we have received an arror on 7 Mar 2012 which is is follows
ORA-1692 : unable to extend lobsegment schema1.Sys_LOB0000126620000004$$ Partition sys_Lob_p265 by 8192 in tablespace DIF-M12
the above error was reported in alert log at 1150 hrs and then a file was added by the local DBA at 1820 hrs i.e after 6 hours.
Now my query is that is there any relation of this error with the BLOB missing from database or if not so what harmful effect there may be on Database as datafile was added after 6 hours
secondly when i see the DF_M12 tablespace usage at EM so its total size is 86 Gb and used is 76Gb but when i see its datafiles so it shows a different story which is opposite to the reported used space i.e only one datafile is showing 25g and rest are not showing any space which means that something is missing so i doubt it is this may be the reason of missing blob or not
kindly comment and guide
Regards
|
|
|
|
| Re: BLOB are missing [message #548414 is a reply to message #548410] |
Thu, 22 March 2012 01:47  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
When you receive this error the statement is aborted and rolled back and so did nothing.
Do not explain what you see, SHOW us: copy and paste what you do and get.
Regards
Michel
[Updated on: Thu, 22 March 2012 01:47] Report message to a moderator |
|
|
|
| Re: BLOB are missing [message #548420 is a reply to message #548414] |
Thu, 22 March 2012 02:04 |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
Hi,
Quote:When you receive this error the statement is aborted and rolled back and so did nothing.
No, i do not receive such error
and secondly i do not perform any command but i will post the alert log and i will also post the screen shot of tablespace DIF_M12 which shows the datafile used space which is contradictiry to usage statistics shown on EM and on sql
Regards
|
|
|
|
|
|
|
|
|
|
| Re: BLOB are missing [message #548747 is a reply to message #548437] |
Sun, 25 March 2012 14:16 |
janakors
Messages: 232
Registered: September 2009
|
Senior Member |
|
|
well its not difficult to understand ? important things is suggestion and advice which is the sole purpose of my post not who did what and bla bla.
have you got any advice ??
Regards
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
