Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ?
I mean wat is the point of pointer update in data dictionary?
- 1 Answers
- 1089 Views
- I also Faced
- E-Mail Answers
Answer Posted / Sarferaz Ahmed
When you use EXCHANGE PARTITION, Oracle doesn't physically move the data from staging table to main table. Instead, it updates pointers in the data dictionary to point to the new location of the partitioned object. This allows faster loading without actually moving the data. The purpose of updating the pointers is to allow easy access and management of the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to add default rules in transformer?
What is rollup component?
What is a rollup component? Explain about it.
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
Hi friends, what are the new features in abinito3.0?
