You should follow the steps as below mentioned:-
- Export the user
- Perform import using the command
imp system/manager file=export.dmp indexfile=newriteindexfile=newfile.sql
This will createimport the data and save all definitions intonewfile.sql
. - Drop necessary objects.
- Run the script
newfile.sql
after altering the tablespaces. - Import from the backup for the necessary objects.