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.



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: 64102
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Problem with Quick Archivelog Generation (merged)
Next Topic: 10g Upgrade
Goto Forum:
  


Current Time: Fri Dec 02 20:59:02 CST 2016

Total time taken to generate the page: 0.08573 seconds