Disable/Remove Partitioning Option

[ronnie]

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

[Thomasps]

In 9i DBMS_REDEFINITION, but in 8i no option in online.

[Thomasps]

But, for less down time you can use this method

Say you have a table

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).

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.

[k.chithra]

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

[Thomasps]

Chithra, I missed out the point. You are right.

[ronnie]

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

[marist89]

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.