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 an Integrity Constrains in Oracle?
How many Dispatcher Processes are created?
What is the use of Oracle Control File?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is Database Buffers ?
What is an oracle database schema?
What is Shared Pool?
Name the ORACLE Background Process?
When will be a segment released?
How to define Data Block size in Oracle?
How the log writer writes the data into database
What is the function of Redo Log in Oracle?