Home » SQL & PL/SQL » SQL & PL/SQL » Split Partition with Subpartition (10.2.0.2 and AIX 5L)
Split Partition with Subpartition [message #366299] Fri, 12 December 2008 12:49 Go to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Hello Folks,


I am having one Partition table, where partition is at MaxValue and I want to split into other partition (range by date ) and in that partition I have to add subpartitions ( list by values ).. I am planning to try with below syntax..

alter table log.xlog_event split partition XLOG_MAX AT(TO_DATE(' 2011-01-01 00:00:00','SYYYY-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN'))
INTO (PARTITION Y10M12 (SUBPARTITION Y10M12_FSM VALUES('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') PARTITION XLOG_MAX UPDATE GLOBAL INDEXES ;



Any improvement?
Re: Split Partition with Subpartition [message #366301 is a reply to message #366299] Fri, 12 December 2008 12:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Any improvement?

In which way?
Either it does what you want, either it does not.

Please 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.
Also always post your Oracle version (4 decimals).

Regards
Michel
Re: Split Partition with Subpartition [message #366303 is a reply to message #366301] Fri, 12 December 2008 12:59 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Michel, I am referring to syntax.
Re: Split Partition with Subpartition [message #366307 is a reply to message #366303] Fri, 12 December 2008 13:10 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And you think we have a SQL syntax analyzer in our head?
Why don't you try it?

Regards
Michel
Previous Topic: Problem with date in bind variable
Next Topic: search file from system
Goto Forum:
  


Current Time: Thu Dec 08 02:08:24 CST 2016

Total time taken to generate the page: 0.33068 seconds