Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rebuilding - indexes (bitmap & function based normal)

Mike301Aug 19 2014 — edited Aug 20 2014

Friends,

DB: 11gR2

OS: Linux

I'm moving some partitioned and non-partitioned tables to new tablespace.

Tables have below index types and wondering how exactly I can rebuild them once I move tables?

1. FUNCTION-BASED NORMAL index

2. BITMAP index

I did searched under metalink but couldn't get some definite answers.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2014

Added on Aug 19 2014

#general-database-discussions

4 comments

1,835 views