Home » SQL & PL/SQL » SQL & PL/SQL » Delete Partition (Oracle 11g Windos)
Delete Partition [message #570713] Wed, 14 November 2012 16:32 Go to next message
jra2007
Messages: 5
Registered: November 2012
Junior Member
Hello,
I am looking for a script to delete partition on table.

Thanks
Re: Delete Partition [message #570714 is a reply to message #570713] Wed, 14 November 2012 17:00 Go to previous messageGo to next message
BlackSwan
Messages: 22520
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
Re: Delete Partition [message #570716 is a reply to message #570714] Wed, 14 November 2012 17:04 Go to previous messageGo to next message
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.
Re: Delete Partition [message #570718 is a reply to message #570716] Wed, 14 November 2012 17:16 Go to previous message
BlackSwan
Messages: 22520
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/
Previous Topic: complex delete and insert (2 Merged)
Next Topic: desc table that you can't select
Goto Forum:
  


Current Time: Tue Jul 29 00:15:16 CDT 2014

Total time taken to generate the page: 0.10445 seconds