Re: Dynamic Partition

From: Ban Spam <ban-spam_at_operamail.com>
Date: Fri, 21 Sep 2001 23:05:14 GMT
Message-ID: <Xns9123A3A529325SunnySD@24.0.3.73>

vishal_lavti_at_yahoo.com (Vishal Lavti) wrote in news:bfd4391d.0109202108.5ab7d66a_at_posting.google.com:

> Hi i want to know can partition be createded dynamically after
> creation of a table?
> Say i have a table with following columns:
> table name :"classprod"
> classid varchar2(10)
> prodid varchar2(10)
> There is another table "childparent" is as
> classid varchar2(10)
> parentclassid varchar2(10)
>
> Now what i want whenever i insert a row into childparent with
> parentclasid null, a new partition should be created in classprod
> having all the prod of the newly inserted classid.
> Is this possible?????
> Thanks in advance.
> Vishal
>

Likely NOT.
The new partition needs to be based upon a "higher ID" than the previous "highest" partition. Received on Fri Sep 21 2001 - 18:05:14 CDT