Oracle Memory Management Question:
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.
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.
| Previous Question | Next Question |
| How can we organize the tablespaces in Oracle database to have maximum performance? | What is redo log buffer? |