-
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.
-
In 9i DBMS_REDEFINITION, but in 8i no option in online.
-
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 01:49 AM.
-
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
-
Chithra, I missed out the point. You are right.
-
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.
-
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
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
|