Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Dynamic Partition
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
Received on Fri Sep 21 2001 - 00:08:03 CDT