Home » SQL & PL/SQL » SQL & PL/SQL » xml indexes in 11g (oracle 11g)
xml indexes in 11g [message #406235] Tue, 02 June 2009 23:32 Go to next message
raffee.v
Messages: 12
Registered: May 2008
Junior Member
on 11g xml indexes are present.

i got one examplfe for this

CREATE INDEX XMLINDEX_IX4 ON TABLE_WITH_XML_COLUMN
(xml_document)
INDEXTYPE IS XDB.XMLIndex
PARAMETERS ('PATHS (INCLUDE (/REQUESTID/ID

)
NAMESPACE MAPPING
(xmlns="http://localhost/xmlschema_bin.xsd")
)

PATH TABLE root_path_table
PATH ID INDEX root_pathid_ix
ORDER KEY INDEX root_orderkey_ix
ASYNC (SYNC ALWAYS) STALE (FALSE)
')
PARALLEL;

i need some examples on order index ,value index xml indexes.
Re: xml indexes in 11g [message #406336 is a reply to message #406235] Wed, 03 June 2009 07:03 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Check this link.

http://forums.oracle.com/forums/thread.jspa?threadID=903011&tstart=0

Regards

Raj
Previous Topic: Binary search tree traversal
Next Topic: pl/sql with ftp
Goto Forum:
  


Current Time: Tue Dec 06 12:17:32 CST 2016

Total time taken to generate the page: 0.13327 seconds