- From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- To: <Brian.Zelli@xxxxxxxxxxxxxxx>, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Nov 2010 08:53:12 -0600
Brian what your describing here sounds more like "archiving" not "partitioning". With archiving you would do more or less what you are saying. Some sort of job running once a month to in effect remove the records from the one table then put them in to some archive table. But if the use wants access to both sets of data at any time this would like mean a view on top of the two tables, which may or may not give you good performance. Or the application would need to be smart enough to know when to go each table. You may also want to look into running the job more then just once a month if the load gets significant. With partitioning you would likely set up some sort of composite partition based on the date and the status fields. Oracle will now automatically put the records into the correct partition, make sure you enable row movement so that as statuses change the row will be moved to the right partition. On the application side, so long as the user's queries use the date and the status fields then oracle will automatically direct the query to the correct partition for the given query. ----------------------- Ric Van Dyke Hotsos Enterprises ----------------------- Hotsos Symposium March 6 - 10, 2011 You have to be there, yea I'm talking to you. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Zelli, Brian Sent: Monday, November 15, 2010 9:16 AM To: oracle-l-freelists Subject: partitioning Ok folks it's been awhile since I had to partition. So the user wants the partition done once a month (for now) based on values in a column. He wants to keep active-type records current and partition off completed or cancelled records. So basically I would set up a script to run on the 1st that would look at the values and just partition off correct? ciao, Brian This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
- From: Zelli, Brian