Code Snippet

Just another Code Snippet site

[Oracle] Enable partitions

Check if partitionning is enabled or not :

select * from v$option where parameter like '%Partition%';

To enable partition feature :

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk part_on
make -f ins_rdbms.mk ioracle

On Solaris, ‘make’ could be installed using following packages :

  • make
  • libgcc
  • libintl
  • libiconv
  • libintl-3.4.0-sol10-x86-local
    make-3.82-sol10-x86-local
    libiconv-1.14-sol10-x86-local
    libgcc-3.3-sol10-intel-local

    , , , ,


    Comments are currently closed.