DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: partition

  1. 04-01-2002, 07:39 PM #1
    Mnemonical
    Mnemonical is offline Senior Member
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    I have never used partitioning. So I tried for the first time:

    create table mnemonical (
    id number primary key,
    b varchar2(10))
    partition by range (id)
    (partition p1 values less than (10),
    partition p2 values less than (maxvalue))

    I got ORA-00439 error. "resource not active: partitioning"

    this is my version:

    SQL*Plus: Release 8.1.7.0.0 - Production on Seg Abr 1 20:36:02 2002

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Conectado a:
    Oracle8i Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production

    SQL>


    Do I have to install something? What?


    Tks in advance.
    F.
    Reply With Quote Reply With Quote
  2. 04-01-2002, 08:11 PM #2
    Kumud
    Kumud is offline Member
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    Partition fetures available in enterprise edition not in standard edition of oracle. so it looks you have standard edition.
    Reply With Quote Reply With Quote
  3. 04-04-2003, 02:17 AM #3
    ligang
    ligang is offline Senior Member
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    Which version support partitioning table?

    I assume this feature is installed from 8.1.7(enterprise version) ,
    Is that right ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com
    Reply With Quote Reply With Quote
  4. 04-04-2003, 03:13 AM #4
    aarroyob
    aarroyob is offline Senior Advisor
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    You could check in the v$option view. Check if the partitoning option is true. If not you need to install it from CD.

    Cheers
    Reply With Quote Reply With Quote
  5. 04-04-2003, 12:11 PM #5
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Which version support partitioning table?

    Originally posted by ligang
    I assume this feature is installed from 8.1.7(enterprise version) ,
    Is that right ?
    No, partitioning is available since Oracle 8.0.5 (well, it was there in 8.0.3, but that was more like a beta release for 8.0).
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width