Hamid, Partitions are basically for the use of Oracle. It allows you to break apart a large table into several smaller sections to help in the management of the table data and to help Oracle find the data you requested. Under ideal conditions, Oracle will only select the smallest area to search for the data you have requested. If the table is 1 tablespace and large in size, it can take an enormous amount of resources to find the data you selected. If the table is partitioned correctly, Oracle will only search the partition/s that it needs to find your data. The application code does not need to be changed. The application will request data from a table and Oracle will determine which partition to use. ROR mª¿ªm
>>> [EMAIL PROTECTED] 01/16/02 04:06PM >>> List, If we use partitioning for a big tables after finish development, do we have to change the code for accReceived: from CONNECT-MTA by galotteressing diffrent partition or this will handle by oracle itself. Thanks Hamid Alavi Office 818 737-0526 Cell 818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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).