We have one partition table which has got 30 partitions as days of month.This is a MIS report related table. We pull data from several other database into external tables.then we will pull data in temp table from external table. Then we will exchange the temp table with partition of that day.(easiest way and fast also). Now my question is. If one partition contains some data and i exchanged it with temp table what will happen to data in partition.will it append data or replace fully.
logically i think exchanging includes only data dict updates so it will fully replace. i searched on google didnt find anything convincing.
Thanks man i got what happens now . actually what i was thinking was correct that data will not get append it will replace tha data. Actually we dont have test env here. So i was unable to try and i dont want trial and error on PROD db. but thanks man.
First thing i will do now is i will make small test env. so that i can do R&D like this .
It was a just wild guess +
Its common and widely used shortform for Hrishikesh
in Maharashatra. (Like mike for michael in foreign countries)
I dont know from which state you are. Anyways thanks man
I dont have much knowledge on share market. just have seen mumbai stock exchange building from outside. and i dont make guesses which will cost my wallet .but still good point to give thought to.I am from pune and currently in coimbatore.