Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
From our Oracle consultant...
When you IMP (import), Oracle will:
1. CREATE THE TABLE
2. INSERT THE ROWS (DATA)
3. RE-CREATE INDEX AUTOMATICALLY
All works again ok.
But, if using:ALTER TABLE (some_table_name) MOVE TABLESPACE (new_created_tablespace); then need to manually rebuild indexes.