Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! 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.