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
- 1091 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is difference between force_error & force_abort? How to use in abinitio graph?
What is a data processing cycle and what is its significance?
i need help from u. i want to learn abinitio. please provide pdfs or material or books.
. What is adhoc multifiles? How to use in abinitio graph?
What is brodcasting and replicate?
Describe the effect of the "checkpoint" t-sql statement?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
What is is a data flow graph?
What are the Types of parallelism in detail?
What will be the output of using partition by Round-Robin after the partiton by key in ab initio?
What is a local lookup?
Teradata 
