First, dump the table's contents to a dump file:
exp userid=system/manager file=move.dmp tables=scott.empUse the correct table name above. Next, drop the table and recreate it in the correct tablespace. Once the table is recreated, import the dump file contents with the IGNORE=Y option.
imp userid=system/manager file=move.dmp tables=scott.emp ignore=y
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.