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
Messages: 36
Registered: September 2006
Location: CHENNAI
Hi All,

I have one XMLTYPE table 'CUST_TABLE'

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


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?

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: 67640
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: Mon Jan 18 17:12:05 CST 2021