SQL Error: ORA-00439: feature not enabled: Partitioning

Posted on 2012-08-17
Last Modified: 2012-08-17
How  to enable Partitioning in Oracle XE ?

select * from V$OPTION;
Partitioning	FALSE

Open in new window

Question by:Swadhin Ray
    LVL 25

    Accepted Solution

    I believe you cannot.  XE is the cut-down free version of Oracle which has several features not included - partitioning is one of these.
    LVL 36

    Assisted Solution

    by:Geert Gruwez
    it's impossible with XE, this feature does not exist in XE:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now