DEVFYI - Developer Resource - FYI

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

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

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

(Continued on next question...)

Other Interview Questions