Answers

Question and Answer:

  Home  Memory Management

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

 132 views

More Questions for you: