By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

b-tree

P: n/a
I am studying on a project that requires to manipulate the index data.
I know oracle uses b-tree index as the default structure.. But where
is this structure stored? Is it a table. If so, can I access data (in
the index)?
Can I access the index from outside (from a java application) Actually
I want to "traverse" the nodes of B-tree.

Thanks a lot..
Utku
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ut**@ce.yildiz.edu.tr (utku) wrote in message news:<99**************************@posting.google. com>...
I am studying on a project that requires to manipulate the index data.
I know oracle uses b-tree index as the default structure.. But where
is this structure stored? Is it a table. If so, can I access data (in
the index)?
Can I access the index from outside (from a java application) Actually
I want to "traverse" the nodes of B-tree.

Thanks a lot..
Utku


Utku, Oracle does not provide a means for a user session to directly
access the contents of an index structure. There is a dump command or
trace event that will perform block dumps of the index blocks:
treedump.

immediate trace name treedump level object_id [of index]

Many computer science books describe the process as does Practical
Oracle 8i by Jonathan Lewis who does it in detail for Oracle b-tree
indexes.

HTH -- Mark D Powell --
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.