Reference Partitioning (Oracle 11g)

Hi,

I want to remove the reference partition already created before. Is it possible to remove?

We need to drop and recreate the table? No other options??

Suggestions??

Views: 93

▶ Reply to This

Replies to This Discussion

Permalink Reply by Leonia Greenidge on December 24, 2013 at 3:52pm

You want to remove a specific partition or the partitioning?

Permalink Reply by Palmira Kostka on December 24, 2013 at 3:54pm

Entire partitioning "partition by reference " should be removed.

 and thanks for your responce

Permalink Reply by Leonia Greenidge on December 24, 2013 at 3:55pm

Well Come Kostka,

You have to recreate the table.
You can use DBMS_REDEFINITION for this. 

Permalink Reply by Lahoma Lucy on January 15, 2014 at 1:46pm

Leonia your answer also solved my problem realy thanks :)

Permalink Reply by Emerson Southward on February 14, 2014 at 6:04pm

If i want to remove a specific partition then??

▶ Reply to Discussion

RSS

Oracle Jobs in US

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service