ORA-00439

Printable View

09-21-2001, 10:06 AM
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
09-21-2001, 10:20 AM
Zaggy

Is the Oracle version standard or enterprise? If it is standard partitioning is not available.
09-21-2001, 10:38 AM
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
09-21-2001, 11:50 AM
ac

Can anyone help with this problem or is it a bug?
09-24-2001, 04:08 AM
ac

Since I don't receive any reply from members or moderators, I guess noone has experienced this problem before.
09-24-2001, 04:22 AM
anil

from which version are you upgrading? tell me the database version from which you took the export
09-24-2001, 05:26 AM
julian

Quote:

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?
09-24-2001, 08:51 AM
ac

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

Thanks,

Ac
09-24-2001, 12:05 PM
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