OraFAQ Forum: SQL & PL/SQL » Delete Partition

Home » SQL & PL/SQL » SQL & PL/SQL » Delete Partition (Oracle 11g Windos)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Delete Partition [message #570713]

Wed, 14 November 2012 16:32

jra2007
Messages: 5
Registered: November 2012

Junior Member

Hello,
I am looking for a script to delete partition on table.

Thanks

Report message to a moderator

Re: Delete Partition [message #570714 is a reply to message #570713]

Wed, 14 November 2012 17:00

BlackSwan
Messages: 20086
Registered: January 2009

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>I am looking for a script to delete partition on table.

delete rows?
or
drop partition?

please Read The Fine Manual yourself
http://docs.oracle.com/cd/E11882_01/server.112/e26088/toc.htm

Report message to a moderator

Re: Delete Partition [message #570716 is a reply to message #570714]

Wed, 14 November 2012 17:04

jra2007
Messages: 5
Registered: November 2012

Junior Member

I am looking to drop partition.

Dynamic partiion is getting created after every 5 days.

I want to delete partition old than 10 days.

Report message to a moderator

Re: Delete Partition [message #570718 is a reply to message #570716]

Wed, 14 November 2012 17:16

BlackSwan
Messages: 20086
Registered: January 2009

Senior Member

the URL to the Fine Manual shows you the valid syntax to DROP PARTITION

post correct & valid SQL that identifies the partitions to be dropped.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Previous Topic:	complex delete and insert (2 Merged)
Next Topic:	desc table that you can't select

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 09:43:45 CDT 2013

Total time taken to generate the page: 0.10830 seconds