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?
- 0 Answers
- 786 Views
- I also Faced
- E-Mail Answers
Why creation of temporary files depends on the value of MAX CORE
how to calculate EME version using unix ?
Have you eveer encountered an error called "depth not equal"?
What is Is_defined(), Is_null(), Is_Blank()?
What is the use of the co> operating system in ab initio?
How to create repository in abinitio for stand alone system(local nt)?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What exactly do you understand with the term data processing and businesses can trust this approach?
How is the partitioning with key different from round robin partition?
How to load the data from an excel sheet to input file in a graph?
How can we increase the loading performance of oracle table in AbInitio?
What do you understand by overflow errors?
Teradata 
