I have few tables under a user schema, which shows that their PK & UK indexes have reached an extent of >20. Now I would like to rebuild then and the oracle is not allowing me to do that. Since it was a STD edition, option of online rebuild is ruled out.

1. Could some one give me the steps on how to do this?

2. Does this pk fragmentation means that the table is also fragemted?

3. On the above scenario, if I do an export then truncate the tables and import,

3a) Would those indexes constrains and their indexes would get dropped, and rebuilt when the import takes place, or is it something that I have to do it manually?

Since this being a pretty well netted, schema, I'm kind of confused on how to do things...

Could some one please help me with some steps?

Mr. T