Disable/Remove Partitioning Option
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Disable/Remove Partitioning Option

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    Disable/Remove Partitioning Option

    Hi,

    I am one of those DBA's who did a typical install of Oracle EE 8.1.7 which install partitioning option by default. Not knowing that there is a license fee associated with it.

    We dont use it but want to disable/remove the option. Is there a way to do it without bringing down the productsion system.

    Thanks
    Ron
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    In 9i DBMS_REDEFINITION, but in 8i no option in online.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    But, for less down time you can use this method

    Say you have a table
    Code:
    create table test2 (
    OWNER          VARCHAR2(30),
    OBJECT_NAME    VARCHAR2(128),
    SUBOBJECT_NAME VARCHAR2(30),
    OBJECT_ID      NUMBER,
    DATA_OBJECT_ID NUMBER,
    OBJECT_TYPE    VARCHAR2(18),
    CREATED        DATE,
    LAST_DDL_TIME  DATE,
    TIMESTAMP      vARCHAR2(19),
    STATUS         VARCHAR2(7),
    TEMPORARY      VARCHAR2(1),
    GENERATED      VARCHAR2(1),
    SECONDARY      VARCHAR2(1))
    partition by range (object_id)
    (partition RANGE_1 values less than (15000),
     partition RANGE_2 values less than (20000),
     partition RANGE_3 values less than (MAXVALUE)
    ) enable row movement;
    Create a temporary table while database is in restricted mode (To avoid simultaneous operations).
    Code:
    create table test3 nologging as select * from test2;
    drop table test2;
    rename test3 to test2;

    Remember to keep Indexes, constraints, triggers and other associated objects. Validate after rebuilding. Export the table before doing the operation.
    Last edited by Thomasps; 12-09-2003 at 12:49 AM.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  4. #4
    Join Date
    Feb 2003
    Posts
    40
    Thomas ,
    Since he says that "We dont use it "which means that he doesnot have partitioned table at all

    I guess that his Q was not make the partitioned table as non-partitioned table instead he wanted to disable Partitioning option itself.(Hope my understanding was right)

    If that is the case ,Instead of EE edition, Oracle Standard Edition can be used which doesnot have feature of

    Oracle partitioning - For database over 100 gigabytes

    or using Orainstaller we can deinstall Oracle Partitioning option,I guess.

    Regards
    Chithra
    K.Chithra
    Oracle DBA

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Chithra, I missed out the point. You are right.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  6. #6
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Thanks for the responses folks but there is no option to uninstall the partitioning option in 8i and we cannot use standard because we need some of the features of Enterprise edition like standby databases.

    I am sure that there might be more people like me who did a typical install and have partitioning option enabled even though they havent paid for it or use it.

    You can check the installed options by querying the v$option view.

    Thanks
    Ron
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Oracle LMS Strikes again, eh?

    The partitioning option must be uninstalled via the oracle installer. However, your database must be down for you to do this.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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