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 |
What is the maximum number of Lock Processes used?
What are the consideration at tehe migration of Oracle 9i to 10G.
What constitute an ORACLE Instance?
What is the use of Oracle Control File?
How will you swap objects into a different table space for an existing database?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
What is an Oracle Data Segment?
Why query fails sometimes ?
How will you create multiple rollback segments in a database ?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
How to find the SGA Size
What is an Oracle Rollback Segment?