-
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
-
Is the Oracle version standard or enterprise? If it is standard partitioning is not available.
______________________
Applications come and go,
but the data remains!
-
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
-
Can anyone help with this problem or is it a bug?
-
Since I don't receive any reply from members or moderators, I guess noone has experienced this problem before.
-
from which version are you upgrading? tell me the database version from which you took the export
Anil
-
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?
-
I took the export from 8.0.5 and I didn't apply any patch.
Thanks,
Ac
-
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
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|