You asked which of two outcomes will occur if you partiton tables after development: 1. "...do we have to change the code for accessing diffrent partition..." or 2. "...this will handle by oracle itself."
Of your two proposed outcomes, 1. is the former and 2. is the latter. Oracle will handle access to table partitions automatically - your code does not have to be modified. I was attempting to answer your question in a succinct manner - sorry for not being clear enough. Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -----Original Message----- Sent: Wednesday, January 16, 2002 4:25 PM To: Multiple recipients of list ORACLE-L what do you mean the latter???? Jack -----Original Message----- Sent: Wednesday, January 16, 2002 2:00 PM To: Multiple recipients of list ORACLE-L The latter. Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -----Original Message----- Sent: Wednesday, January 16, 2002 3:07 PM To: Multiple recipients of list ORACLE-L List, If we use partitioning for a big tables after finish development, do we have to change the code for accessing diffrent partition or this will handle by oracle itself. Thanks Hamid Alavi Office 818 737-0526 Cell 818 402-1987 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
