I have oracle 8.1.5 on NT and I see partitioning is not enabled ,when I try to create a partitioned table it gives error and in v$option also it gives false to partitioning.I checked in CD also but there no component is found regarding partitioning.also I see
Export transportable tablespaces false
Function-based indexes FALSE
Instead-of triggers FALSE
will i be able to use these features.or these r not in 8.1.5 ,what's the issue?
11-11-2000, 04:07 AM
Do you have Workgroup Server (Standard Edition)?? This edition will not have the options.
11-11-2000, 05:50 AM
I am using enterprise edition of oracle 8i version-8.1.5
if that donot have partitioning option.
11-11-2000, 05:59 AM
I believe there is a way to enable those options, but am unaware of how this is done. Check for notes on Metalink, I'm sure they'll have it.
11-11-2000, 11:56 PM
Try running this $ORACLE_HOME\rdbms\admin\ Catpart.sql in sys.If it doesnt work,then I think u must have not enabled the partition option while instalation.I have faced this some time before.So u have to reinstall Oracle, with the partition option checked while installation.
11-13-2000, 12:45 AM
i donot see any check option in CD regarding partitioning.I have checked it thoroughly,it only says typical or custom installation,I also checked all compnents of custom installation.anybody know about it?
11-13-2000, 03:54 AM
I think you may be using Workgroup Server (Standard edition).
11-13-2000, 05:29 AM
can u tell whats the difference,why this workgroup server version is used?
11-13-2000, 10:46 AM
SELECT * FROM V$VERSION;
The first line should indicate whether or not you have Enterprise Edition.