Home » RDBMS Server » Server Administration » Change to logging in a hash subpartition (Oracle 10g)
Change to logging in a hash subpartition [message #364699] Tue, 09 December 2008 12:41 Go to next message
mafc73
Messages: 38
Registered: November 2006
Member
Hi,

I have a table partitioned by range and subpartitioned by hash. The partition and subpartitions are in nologgin mode. I want to change to logging. I have changed to logging mode the partition but I can't change the subpartitions.

To change the partition to logging I have used this sentence 

ALTER TABLE tab1
MODIFY DEFAULT ATTRIBUTES FOR PARTITION p37779 LOGGING;


I have probed with

ALTER TABLE ods.ADWF_RM_EVENT MODIFY SUBPARTITION p37779_S1 LOGGING;

but I get an error. Invalid option for alter table.


Is posibble to change the logging mode at subpartition level?

This table is very big and I can't drop it and then recreate.


Thanks.



Report message to a moderator

Re: Change to logging in a hash subpartition [message #364701 is a reply to message #364699] Tue, 09 December 2008 12:48 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session.
Post create table statement.
Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and use code tags.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Previous Topic: Problem with Quick Archivelog Generation (merged)
Next Topic: 10g Upgrade
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 20:52:20 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.