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

Thread: ORA-00439

  1. #1
    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

  2. #2
    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!

  3. #3
    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

  4. #4
    Join Date
    Nov 2000
    Posts
    178
    Can anyone help with this problem or is it a bug?

  5. #5
    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.

  6. #6
    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

  7. #7
    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?


  8. #8
    Join Date
    Nov 2000
    Posts
    178
    I took the export from 8.0.5 and I didn't apply any patch.

    Thanks,

    Ac

  9. #9
    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!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width