How will you swap objects into a different table space for
an existing database?
Answers were Sorted based on User's Feedback
Answer / kd
using expdp to export objects, then using impdp
remap_tablespace to map the objects to another tablespace.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / orawhiz
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.
Is This Answer Correct ? | 0 Yes | 2 No |
How will you create multiple rollback segments in a database ?
What is an Integrity Constrains in Oracle?
What is Dedicated Server Configuration?
How does Space allocation table place within a block ?
How will you monitor rollback segment status ?
What is the significance of having storage clause ?
What are the two types of Server Configurations?
What are the uses of Oracle Rollback Segment?
What is a Rollback segment entry ?
Which parameter in Storage clause will reduce no. of rows per block?
What is the function of Redo Log in Oracle?
When Does DBWR write to the database?