-
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.
-
Partition fetures available in enterprise edition not in standard edition of oracle. so it looks you have standard edition.
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|