- 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.