RE: local partition index question
Yes. This is true -- even in Oracle 9i Caver -Original Message- Sent: Monday, March 11, 2002 9:58 AM To: Multiple recipients of list ORACLE-L Hi all, I am new to partition and I was told the following statement and I couldn't verify it in the doc. Could someone please tell me if it's true or not? The partition column must be included in the primary key for the resulting unique index to be locally partitioned. Thanks _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba 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: Toepke, Kevin M 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).
RE: local partition index question
Title: RE: local partition index question This subject nicely raises an question(s) I have. We have some tables complete with PK and FK's referencing them. We have now added a create_timestamp column to the tables and wish to partition the tables using the range (create_timestamp). No problems. However we canot create a PK index because, as you state Cherie, the PK does not contain the column that we have partitioned on. What workarounds are there. I can create a unique index on the PK columns (name,id for example)but it also affects the FK that other tables use to reference this table. How do other people sites work around this John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 11 March 2002 15:38 To: Multiple recipients of list ORACLE-L Subject: Re: local partition index question Yes, that is true. I've seen that to be the case in our warehouse database. Cherie Machler Oracle DBA Gelco Information Network oracle dba oracle12i@hot To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mail.com cc: Sent by: Subject: local partition index question [EMAIL PROTECTED] om 03/11/02 08:58 AM Please respond to ORACLE-L Hi all, I am new to partition and I was told the following statement and I couldn't verify it in the doc. Could someone please tell me if it's true or not? The partition column must be included in the primary key for the resulting unique index to be locally partitioned. Thanks _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba 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: 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). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =
local partition index question
Hi all, I am new to partition and I was told the following statement and I couldn't verify it in the doc. Could someone please tell me if it's true or not? The partition column must be included in the primary key for the resulting unique index to be locally partitioned. Thanks _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba 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).
Re: local partition index question
Yes, that is true. I've seen that to be the case in our warehouse database. Cherie Machler Oracle DBA Gelco Information Network oracle dba oracle12i@hot To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mail.comcc: Sent by: Subject: local partition index question [EMAIL PROTECTED] om 03/11/02 08:58 AM Please respond to ORACLE-L Hi all, I am new to partition and I was told the following statement and I couldn't verify it in the doc. Could someone please tell me if it's true or not? The partition column must be included in the primary key for the resulting unique index to be locally partitioned. Thanks _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba 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: 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).