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

Home -> Community -> Mailing Lists -> Oracle-L -> partitioning a non-partitioned table

partitioning a non-partitioned table

From: Suresh Chaganti <chaganti.suresh_at_gmail.com>
Date: Mon, 27 Aug 2007 08:44:39 -0500
Message-ID: <1828353c0708270644y62320a67xa65eb66371b431a2@mail.gmail.com>


Hello

Can any one point me to a doc on partitioning a non-partitioned table. I couldnt find one on metalink

I know we can use DBMS_REDEFINITION package startin 9i. But this has several restriction including inability to use materialized views, LONG columns etc..Also I have some 8i databases as well.

Even if I need to take the table offline, it is ok, but I am looking for definitive guidance on the methodology to ensure all the indexes, constraints will be intact after re-org.

Thank you

Suresh

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 27 2007 - 08:44:39 CDT

Original text of this message

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