1.

How Will You Swap Objects Into A Different Table Space For An Existing Database?

Answer»

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

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


Discussion

No Comment Found

Related InterviewSolutions