Memory Management Interview Question:

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

Submitted by: Administrator

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.
Submitted by: Administrator