Home » SQL & PL/SQL » SQL & PL/SQL » Partition Creation (Oracle 11G, Unix)
Partition Creation [message #576989] Mon, 11 February 2013 10:31 Go to next message
nagaraju.ch
Messages: 98
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 #576990 is a reply to message #576989] Mon, 11 February 2013 11:00 Go to previous messageGo to next message
Michel Cadot
Messages: 60010
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have nothing to do, data are always inserted in the correct partition whatever they are.

Regards
Michel
Re: Partition Creation [message #576994 is a reply to message #576989] Mon, 11 February 2013 11:55 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2079
Registered: January 2010
Senior Member
nagaraju.ch wrote on Mon, 11 February 2013 11:31
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).


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 #577101 is a reply to message #576994] Tue, 12 February 2013 06:50 Go to previous messageGo to next message
nagaraju.ch
Messages: 98
Registered: July 2007
Location: bangalore
Member
Thanks Guys

I thought we need to manually do the partition when we load previous days data.

Re: Partition Creation [message #577109 is a reply to message #577101] Tue, 12 February 2013 07:44 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2079
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

Re: Partition Creation [message #577114 is a reply to message #577109] Tue, 12 February 2013 08:31 Go to previous message
Michel Cadot
Messages: 60010
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And if it is a range partition and they are dates that are lower than the latest used one then there already exists a partition to receive them.

Regards
Michel

[Updated on: Tue, 12 February 2013 08:32]

Report message to a moderator

Previous Topic: Execute the expression in select statement
Next Topic: to get common records
Goto Forum:
  


Current Time: Sun Dec 21 04:11:50 CST 2014

Total time taken to generate the page: 0.57307 seconds