Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Partitions

RE: Partitions

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Wed, 16 Jan 2002 15:52:45 -0800
Message-ID: <F001.003F21BF.20020116152033@fatcity.com>

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
japplewhite_at_inetprofit.com
(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
japplewhite_at_inetprofit.com
(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: japplewhite_at_inetprofit.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).
Received on Wed Jan 16 2002 - 17:52:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US