 SYS_LOB0000 in dba_segments [message #475160] |
Mon, 13 September 2010 06:48  |
madhavamanohar
Messages: 58
Registered: February 2009
|
Member |
|
|
Hi Team,
One of my production database TS is growing with the LOB segments for the Application sachems.Please find the LOB's below all the segments are creating on its own name..!
SYS_LOB0000395198C00001$$
USER_TS B81
SYS_LOB0000395238C00014$$
USER_TS B84
SYS_LOB0000395256C00006$$
USER_TS B88
Please advice
Regards
Mano.
|
|
|
|
|
|
| Re: SYS_LOB0000 in dba_segments [message #475165 is a reply to message #475161] |
Mon, 13 September 2010 07:02  |
madhavamanohar
Messages: 58
Registered: February 2009
|
Member |
|
|
Hi Michel,
Thanks for your reply...
I queried and got the Table name,Column name...Then what to do..!
Any idea on the mentioned LOB segment list, why & how these objects are being created with the own name into application schema..!
Regards
Mano
|
|
|
|
|
|
| Re: SYS_LOB0000 in dba_segments [message #475247 is a reply to message #475177] |
Mon, 13 September 2010 23:44 |
madhavamanohar
Messages: 58
Registered: February 2009
|
Member |
|
|
Dear Michel,
I am asking about ..Since it is an application schema..How the LOB objects got created with the name...SYS_LOB0000***
and do you have any idea on the mentioned LOB segment list, why & how these objects are being created with the own name into application schema..!
OWNER TABLE_NAME COLUMN_NAME SEGMENT_NAME INDEX_NAME
-------------------- ------------------------- -------------------- ------------------------------ ------------------------------
B3 BXML XML SYS_LOB0000249626C00007$$ SYS_IL0000249626C00007$$
B2 REANK TSG SYS_LOB0000348436C00014$$ SYS_IL0000348436C00014$$
Thanks
Mano
[Updated on: Mon, 13 September 2010 23:44] Report message to a moderator |
|
|
|
| Re: SYS_LOB0000 in dba_segments [message #475269 is a reply to message #475247] |
Tue, 14 September 2010 01:44 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:I am asking about ..Since it is an application schema..How the LOB objects got created with the name...SYS_LOB0000***
It is system generated names because Oracle has to name his segments and you don't (and can't) give a name to your LOB ones.
LOBs are not in the same segment than the table, they are in a different segment because they are not managed in the same way than the other columns.
Regards
Michel
[Updated on: Tue, 14 September 2010 09:41] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
