Oracle-L: RE: partitioning

From: Jay Mehta <Jmehta_at_ctisinc.com>
Date: Wed, 22 May 2002 15:51:58 -0800
Message-ID: <F001.00468893.20020522155158@fatcity.com>

Dennis,

Sure, you need to use INSTEAD OF triggers on views. I don't think Oracle8 supports INSTED OF triggers, but Oracle8i does. I was working on a project some time ago where we had used partitioned views and instead of triggers to implement functionality that's somewhat similar to partitioning option! Sure, you don't have all the nice features at your disposal for administration and maintenance that partitioning provides, but when you look at the price difference between the two choices, and all you need is simple and basic partitioning, then partitioning view might work for you, and save you some big bucks :)

HTH and GL!

Jay

-----Original Message-----
Sent: Wednesday, May 22, 2002 7:12 PM
To: Multiple recipients of list ORACLE-L

Quick memory test - were you able to create partition views such that you could insert rows into view? In other words, could you create multiple tables joined in a view, then be able to insert into the view? If anybody can recall, I would appreciate it. Thanks. Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, May 22, 2002 5:50 PM
To: Multiple recipients of list ORACLE-L

Partition views, after all, were not that bad!

-----Original Message-----
Sent: Wednesday, May 22, 2002 5:21 PM
To: Multiple recipients of list ORACLE-L

Damn!

-----Original Message-----
Sent: Wednesday, May 22, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L

Absolutely true! Even worse, it is an option on top of Enterprise Edition, so you can't license Standard Edition and buy the partitioning option.

-----Original Message-----
Sent: Wednesday, May 22, 2002 12:06 PM
To: Multiple recipients of list ORACLE-L

None

It is an option (Means you pay).

Yechiel Adar
Mehish

Original Message ----- To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com> Sent: Wednesday, May 22, 2002 6:38 PM

Hi all,

Does anybody know with what version of Oracle partitioning was included at no extra cost?

Thanks!

Jerry

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.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: Cunningham, Gerald
INET: Gerald.Cunningham_at_usi.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

This electronic message contains information from CTIS, Inc., which may be company sensitive, proprietary, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipients named above. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify us immediately at MIS_at_ctisinc.com.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jay Mehta
INET: Jmehta_at_ctisinc.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: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jay Mehta
INET: Jmehta_at_ctisinc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------