Jun 21, 2006 #1 oradba101 MIS Joined Feb 28, 2003 Messages 318 Location US Good morning, I have an accounts receivable table that I want to partition into months, quarter, and fiscal year. How would I go about doing this? Regards, William Chadbourne Oracle DBA
Good morning, I have an accounts receivable table that I want to partition into months, quarter, and fiscal year. How would I go about doing this? Regards, William Chadbourne Oracle DBA
Jun 27, 2006 #2 Beilstwh Programmer Joined Jul 13, 2005 Messages 819 Location US See http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c12parti.htm#464767 Bill Oracle DBA/Developer New York State, USA Upvote 0 Downvote
See http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c12parti.htm#464767 Bill Oracle DBA/Developer New York State, USA
Jul 5, 2006 #3 Beilstwh Programmer Joined Jul 13, 2005 Messages 819 Location US Be aware that partationing is an option. It installs automatically, but should not be used until paid for. See the following link for 10g options http://www.oracle.com/database/product_editions.html Bill Oracle DBA/Developer New York State, USA Upvote 0 Downvote
Be aware that partationing is an option. It installs automatically, but should not be used until paid for. See the following link for 10g options http://www.oracle.com/database/product_editions.html Bill Oracle DBA/Developer New York State, USA