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

Thread: partition

  1. #1
    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.

  2. #2
    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.

  3. #3
    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

  4. #4
    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

  5. #5
    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?

Posting Permissions

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



Click Here to Expand Forum to Full Width