| Partition Creation [message #576989] |
Mon, 11 February 2013 10:31  |
nagaraju.ch
Messages: 68
Registered: July 2007
Location: bangalore
|
Member |
|
|
Hi
I have table and it will contain huge data, so we have implemented as partitioned table. Every day when we load data into table there will be one partition created by the ETL Process by default with the Date Column(day wise). Now we may receive data for the previous days as well(Date column in table will have the date associated to the Data). No i would like the data should be inserted into partition which assocites to its own date.
Could someone please advise how can we achieve this?
|
|
|
|
|
|
| Re: Partition Creation [message #576994 is a reply to message #576989] |
Mon, 11 February 2013 11:55  |
Solomon Yakobson
Messages: 1397
Registered: January 2010
|
Senior Member |
|
|
nagaraju.ch wrote on Mon, 11 February 2013 11:31Every day when we load data into table there will be one partition created by the ETL Process by default with the Date Column(day wise).
Is ETL process using interval partitioning? If so, nothing to worry about - each day will be a separate partition. If ETL process is using some other way, please explain.
SY.
|
|
|
|
|
|
| Re: Partition Creation [message #577109 is a reply to message #577101] |
Tue, 12 February 2013 07:44 |
Solomon Yakobson
Messages: 1397
Registered: January 2010
|
Senior Member |
|
|
Again, partitions are created automatically ONLY if interval partitioning is used (doesn't matter if it is date, number, string of any other partitioning column datatype). Otherwise you have to pre-create partitions manually when inserting data that doesn't fit into any of existing partitions.
SY.
[Updated on: Tue, 12 February 2013 07:45] Report message to a moderator |
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
