Oracle 9i Database index vs data

That is typical and nothing to be alarmed about. Indexes often take more storage space than tables. What causes it is that you can have tables with lots of rows and lots of indexes. For example, if you have 10 indexes on GLTRANS and you have 10 million rows, you're storing 10 million + (10 * 10 million) = 110 million rows in the database. Although each row of data might be 1000 bytes long, the indexes are usually shorter, but when you consider 10 indexes each storing some part of each row, it adds up...