Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. 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.