Home » RDBMS Server » Server Administration » Need XMLTYPE & LOB segment explanation (11g)
Need XMLTYPE & LOB segment explanation [message #642746] Fri, 18 September 2015 01:54 Go to next message
karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI
Member
Hi All,

I have one XMLTYPE table 'CUST_TABLE'

and it has one LOB segment and one index segment as follow

SYS_LOB0003205399C00003$$
SYS_IL0003205399C00003$$


Kindly calrify me on the below queries

1.) How this LOB segment and Index segments are created for this table?
2.) If I drop these LOB Segment and Index Segment what will happen to Table?


Thanks
Re: Need XMLTYPE & LOB segment explanation [message #642749 is a reply to message #642746] Fri, 18 September 2015 02:58 Go to previous message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1) What "how" means here?
2) You cannot drop these segments

Previous Topic: 12c Standard Edition One Installation fails and need fixes no updates from Oracle
Next Topic: PGA memory allocation
Goto Forum:
  


Current Time: Wed Feb 21 06:09:17 CST 2018

Total time taken to generate the page: 0.09302 seconds