ORA-00439

[ac]

Dear Moderators,

I was upgrading to Oracle 8.1.7. and received the following error during import:
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Partitioning

Can you please help me on a work around please.

AC

[Zaggy]

Is the Oracle version standard or enterprise? If it is standard partitioning is not available.

[ac]

The Version is Enterprise Edition as you can see below:

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

Ac

[ac]

Can anyone help with this problem or is it a bug?

[ac]

Since I don't receive any reply from members or moderators, I guess noone has experienced this problem before.

[anil]

from which version are you upgrading? tell me the database version from which you took the export

[julian]

Originally posted by ac
Dear Moderators,

I was upgrading to Oracle 8.1.7. and received the following error during import:
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Partitioning

Can you please help me on a work around please.

AC

Oracle claims that after installing cumulative patch 1833534, then the distributed and partitioning options are disabled. Did you install 1833534?

[ac]

I took the export from 8.0.5 and I didn't apply any patch.

Thanks,

Ac

[sambavan]

Looks like that the partition option had not been enabled/installed in your database version. Try the following steps to enable the partitioning:


1. Mount the 8.x.x cdrom as 'root'

2. Login as 'oracle', shutdown the databases using
your 8.x.x ORACLE_HOME.

3. Change to the cdrom mount directory and load orainst

% cd /cdrom_mount/orainst
% ./orainst

4. Select Default.

5. Select Install, Upgrade or Deinstall Software

6. Select Add/Upgrade Software

7. Find the product Oracle Options. It should have a plus
sign (+) on the left hand side.

8. Highlight the product and press the ENTER key
to expand it.

9. Scroll down and select Partitioning Option product.


Sam