Interested to Buy Any Domain ? << Click Here >> for more details...
How will you swap objects into a different table space for
an existing database?
- 2 Answers
- 5023 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 |
What are Oracle Schema Objects?
What is Shared SQL Area?
what is the role of archiever
How will you estimate the space required by a non-clustered tables?
List the factors that can affect the accuracy of the estimations ?
What is meant by recursive hints ?
Which parameter in Storage clause will reduce no. of rows per block?
What do Redo Log Buffers contain?
What is Server Process?
How many Dispatcher Processes are created?
Can a View based on another View in Oracle?
What is PGA?
Oracle General 
