Skip to Main Content

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Rob.

Asked: January 23, 2001 - 11:24 am UTC

Last updated: January 28, 2009 - 7:56 am UTC

Version: 8.1.6

Viewed 1000+ times

You Asked

Hi Tom,

I want to avail myself of F-B-indexes, and am trying to issue DDL simialr to the following:

CREATE INDEX ix_ssn_part4_bulk08
ON x_tbindpvoiecvbulk08 (SUBSTR(ssn,6,4))
TABLEPSACE testbulkindex
PCTFREE 5
STORAGE (INITIAL 10M NEXT 10M PCTINCREASE 0 )
UNRECOVERABLE;

Problem is, I get an ORA-00439 "feature not enabled" message. I've tried to work around this by adjusting the init.ora parameters COMPATIBLE (up to 8.1.6) and also QUERY_REWRITE_ENABLED to TRUE. But I still receive the ORA-00439. I'm running 8.1.6 on AIX. Maddeningly, my little Personal Oracle8i DB running on an NT workstation has no problem with this DDL.

Do you know what's wrong?
Thanks,
Rob



and Tom said...

A matrix of what features/options are available with Enterprise, Standard and Personal Oracle can be found at:

</code> http://docs.oracle.com/cd/A81042_01/DOC/server.816/a76962/ch4.htm#73594 <code>

Function Based Indexes are part of Enterprise Edition. Most of Enterprise is also available in Personal for development purposes. Function based indexes are not available on Oracle Standard Edition.

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

9i Personal Edition on Win98

Richard Armstrong-Finnerty, October 21, 2002 - 8:45 am UTC

Hi,

The response was great for 8.0, but what about 9i?

I have 9i Personal Edition at home, on Win98, and recently bought a copy of Beginning Oracle Programming. I have attempted installation of the new Sample Schemas (HR, OE etc.), as per Appendix D, but am getting ORA-00439 (Partioning not allowed) when installing the Sales History schema.

Is partitioning possible with this edition? If so, how's it done?

Regards,

Richard

Tom Kyte
October 21, 2002 - 9:18 am UTC

Partitioning is an option that is separately licensed.

</code> http://docs.oracle.com/docs/cd/B10501_01/server.920/a96531/ch5_edit.htm#73594 

is the link for 9i like the 8i link above.
http://docs.oracle.com/docs/cd/B10501_01/server.920/a96539/installa.htm#4371 <code>

points into the sample schemas documentation -- the SH schema is not available for use with PE or SE as per that document. The remainder should install just fine.

You should have no issues installing all of the samples beyond that.

A reader, October 04, 2005 - 4:55 pm UTC


ORA-00439

A reader, January 26, 2009 - 8:28 am UTC

Tom,

One of our Databases writhe the following error in the alert.log (twice daiyl at 6:00 and 12:00). Is it an Orcle job running in the background? Can (and if yes how) we disable this (otherwise we got page with oracle generic error in the alert.log)

Mon Jan 26 12:00:00 2009
Unable to restore resource manager plan to '':
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Database resource manager
Tom Kyte
January 28, 2009 - 7:56 am UTC

how about "is this a job we are running...."

query dba_jobs, see what jobs you have scheduled.
query dba_scheduler_jobs as well, you might have used that.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.