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).

Reply via email to