Database Administration (MOSC)

MOSC Banner

IMPORT indexes - taking long

edited Mar 11, 2014 12:00PM in Database Administration (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center