IMPORT indexes - taking long
I need to export / import various schemes. the export is taking 1 hour 40 minutes to export 24 schemes but the import the same in new database, takes six hours. I realized that building indexes taking long time.
what is the easiest way to recreate indexes on a new databases and to move to diff. tablespaces?
1. there are 4800 indexes in this export
2. presently, 3000 indexes (out of 4800 total) with only 1 extents, so lots of them can be moved to smaller extent size tablespaces to save space.
3. I would like to move this indexes to appropriate tablespace, i.e. small, medium and larger extent tablespaces, so it will not waste space.