How will you swap objects into a different table space for
an existing database?
- 2 Answers
- 4113 Views
- I also Faced
- E-Mail Answers
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 to define Data Block size in Oracle?
What is an Oracle Data Dictionary?
What is a Rollback segment entry ?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
Why query fails sometimes ?
what is ORACLE MEMORY STRUCTURES
Name the ORACLE Background Process?
How to find the current session sid
What is Database Buffers ?
What is meant by redo log buffer ?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What are the consideration at tehe migration of Oracle 9i to 10G.
Oracle General 
