DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-00439

  1. 09-21-2001, 10:06 AM #1
    ac
    ac is offline Member
    Join Date
    Nov 2000
    Posts
    178
    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
    Reply With Quote Reply With Quote
  2. 09-21-2001, 10:20 AM #2
    Zaggy
    Zaggy is offline Member
    Join Date
    Apr 2001
    Posts
    219
    Is the Oracle version standard or enterprise? If it is standard partitioning is not available.
    ______________________
    Applications come and go,
    but the data remains!
    Reply With Quote Reply With Quote
  3. 09-21-2001, 10:38 AM #3
    ac
    ac is offline Member
    Join Date
    Nov 2000
    Posts
    178
    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
    Reply With Quote Reply With Quote
  4. 09-21-2001, 11:50 AM #4
    ac
    ac is offline Member
    Join Date
    Nov 2000
    Posts
    178
    Can anyone help with this problem or is it a bug?
    Reply With Quote Reply With Quote
  5. 09-24-2001, 04:08 AM #5
    ac
    ac is offline Member
    Join Date
    Nov 2000
    Posts
    178
    Since I don't receive any reply from members or moderators, I guess noone has experienced this problem before.
    Reply With Quote Reply With Quote
  6. 09-24-2001, 04:22 AM #6
    anil
    anil is offline Junior Member
    Join Date
    Sep 2001
    Location
    Chennai, India
    Posts
    4
    from which version are you upgrading? tell me the database version from which you took the export
    Anil
    Reply With Quote Reply With Quote
  7. 09-24-2001, 05:26 AM #7
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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?

    Reply With Quote Reply With Quote
  8. 09-24-2001, 08:51 AM #8
    ac
    ac is offline Member
    Join Date
    Nov 2000
    Posts
    178
    I took the export from 8.0.5 and I didn't apply any patch.

    Thanks,

    Ac
    Reply With Quote Reply With Quote
  9. 09-24-2001, 12:05 PM #9
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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