I'm an Oracle newbie (only just read the 12th manual...)
Is there an easy way to determine what columns of what tables have been
indexed - in such a manner as to make it possible to replicate the
index on another database i.e sql create statements?
The closest I've seen so far is the indexfile option on database import.
I *think* that I want to drop all my indexes before I perform a large
data load (using sqlload) - but I need an easy way to put all the
indexes back.
I'm using Oracle 7.1.6 on HP UX 10.
Andy
--
Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
PGP key available on request
===============================================================
Think honk if you're a telepath.