partitioning false in v$option
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: partitioning false in v$option

  1. #1
    Join Date
    Jun 2000
    Posts
    104
    hello everybody,
    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?

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Do you have Workgroup Server (Standard Edition)?? This edition will not have the options.

  3. #3
    Join Date
    Jun 2000
    Posts
    104
    halo,
    I am using enterprise edition of oracle 8i version-8.1.5
    if that donot have partitioning option.

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    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.

  5. #5
    Join Date
    Aug 2000
    Posts
    87
    Hi ,
    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.

    Cheers,
    Vinod Kumar.

  6. #6
    Join Date
    Jun 2000
    Posts
    104
    hello vinodkmg,
    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?

  7. #7
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I think you may be using Workgroup Server (Standard edition).

  8. #8
    Join Date
    Jun 2000
    Posts
    104
    can u tell whats the difference,why this workgroup server version is used?

  9. #9
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    SELECT * FROM V$VERSION;

    The first line should indicate whether or not you have Enterprise Edition.

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