Question: What are transportable table spaces and the need to use them?
Answer: Transportable tablespaces are the fastest way for moving large volume of data between two oracle databases. We can use the transportable tablespaces feature to copy a set of tablespaces from one oracle database to another. Moving data using transportable tablespaces is much faster than performing either an export/import or unload/load the same data.
Question:
What are transportable table spaces and the need to use them? Answer:
Transportable tablespaces are the fastest way for moving large volume of data between two oracle databases. We can use the transportable tablespaces feature to copy a set of tablespaces from one oracle database to another. Moving data using transportable tablespaces is much faster than performing either an export/import or unload/load the same data. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.
Answer should be complete in itself.
Related Questions
View Answer
What are transportable table spaces and the need to use them?