Pages

Saturday, 9 March 2013

How will you swap objects into a different table space for an existing database?





- Export the user

- Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql.

- Drop necessary objects.

- Run the script newfile.sql after altering the tablespaces.

- Import from the backup for the necessary objects.

No comments:

Post a Comment