RE: Partitions

Thanks Ron,
So it's better I put partitions in deffrent tablespace and also for better performance in diffrent physical disks, it will helps. I am going to do the partition on Creation date or on Primary Key(PK is a sequence number), don't know can we use PK as a range for partitioning or not?
Thanks again for your help.

-----Original Message-----
Sent: Thursday, January 17, 2002 6:02 AM To: Multiple recipients of list ORACLE-L

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

>>> hamid.alavi_at_quovadx.com 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: hamid.alavi_at_quovadx.com 

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: ListGuru_at_fatcity.com (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: RROGERS_at_galottery.org

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: ListGuru_at_fatcity.com (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).
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: hamid.alavi_at_quovadx.com

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: ListGuru_at_fatcity.com (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).