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 |
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is the function of ARCH?
What is the maximum size of a oracle9i database?
How to find the current session sid
What are Oracle Schema Objects?
What is an Integrity Constrains in Oracle?
What is an oracle database schema?
What is advantage of having disk shadowing/ Mirroring ?
What is meant by Redo Log file mirrorring ? How it can be achieved?
How to define Data Block size in Oracle?
What is an Oracle Data Segment?
What is the function of checkpoint(CKPT)?