By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
- Export the table.
exp userid=system/manager file=t.dmp tables=my_table
- Use the dump file to create a SQL file to re-create the table.
imp userid=system/manager file=t.dmp tables=my_table show=y log=t.sql
- Step 2 will create a SQL script (t.sql). Edit this script to contain just the CREATE TABLE command. Modify the TABLESPACE parameter to create the table in the correct tablespace.
- Drop the table.
- Precreate the table by running the script you modified in step 3.
- Import the table's contents.
imp userid=system/manager file=t.dmp tables=my_table 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.