Home » RDBMS Server » Server Administration » Enabling Option Partitioning (Oracle 9.2.0.4)
Enabling Option Partitioning [message #398479] Thu, 16 April 2009 06:50 Go to next message
garther
Messages: 4
Registered: April 2009
Location: Poland
Junior Member

Hi,

I had an installation of Oracle 9.2.0.4 without Partitioning support.
I've installed this option and it's visible in "Installed Products".

Problem is that when I do:

select * from v$option where parameter = 'Partitioning';

I get FALSE.

What might be wrong? Do i have to enable somehow the partitioning?

Thx for any advice!
Re: Enabling Option Partitioning [message #398482 is a reply to message #398479] Thu, 16 April 2009 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Solution depends on your OS you didn't provide.

Regards
Michel
Re: Enabling Option Partitioning [message #398483 is a reply to message #398482] Thu, 16 April 2009 07:09 Go to previous messageGo to next message
garther
Messages: 4
Registered: April 2009
Location: Poland
Junior Member

Yes i forgot Smile

It's installed under Linux (Gentoo, x86).
Re: Enabling Option Partitioning [message #398494 is a reply to message #398483] Thu, 16 April 2009 08:17 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink note 225688.1, "How to resolve "ORA-439: Feature not enabled; Partitioning" error"

Regards
Michel
Previous Topic: creating data file on different drive (merged 3)
Next Topic: oracle reports
Goto Forum:
  


Current Time: Tue Dec 06 04:17:58 CST 2016

Total time taken to generate the page: 0.05719 seconds