The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.
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.