Home » SQL & PL/SQL » Client Tools » Drop a hash partition (Oracle 9.2)
Drop a hash partition [message #312632] Wed, 09 April 2008 08:45 Go to next message
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
Member
Is there a different way to drop a hash partion than range and list. I tried the folllowing statement and also along with few other options but couldn't get it working.
alter table table_name drop partition partition_name.
Re: Drop a hash partition [message #312634 is a reply to message #312632] Wed, 09 April 2008 08:49 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>couldn't get it working
I couldn't get my car working.
Please tell me how to make it go.


Please read & FOLLOW posting guidelines below

http://www.orafaq.com/forum/t/88153/0/
Re: Drop a hash partition [message #312636 is a reply to message #312632] Wed, 09 April 2008 08:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From doc, ALTER TABLE statement:
Quote:
Restrictions on Dropping Table Partitions Dropping table partitions is subject to the following restrictions:

You cannot drop a partition of a hash-partitioned table. Instead, use the coalesce_table_partition clause.

...

Regards
Michel

[Updated on: Wed, 09 April 2008 08:54]

Report message to a moderator

Re: Drop a hash partition [message #312643 is a reply to message #312636] Wed, 09 April 2008 09:14 Go to previous messageGo to next message
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
Member
Michel, Pls give me the statement.

Thanks
Re: Drop a hash partition [message #312664 is a reply to message #312643] Wed, 09 April 2008 10:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The doc is on line and available at http://tahiti.oracle.com.

Regards
Michel

Re: Drop a hash partition [message #312842 is a reply to message #312664] Wed, 09 April 2008 21:53 Go to previous messageGo to next message
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
Member
The link did not help are you able to paste the DDL statement.

Thanks
Re: Drop a hash partition [message #312848 is a reply to message #312842] Wed, 09 April 2008 22:24 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
chintu00 wrote on Thu, 10 April 2008 12:53
The link did not help are you able to paste the DDL statement.

How hard did you look?

Go to the link specified by Michel.

You will see a page showing links to documentation for different versions of the database. Choose the version that you are using and follow that link.

Depending on which version you choose, you will get a different screen. Here's where you need to use some initiative. Somewhere on that page will be a link to a SQL Reference manual. Find it. Click it.

Once you have opened the SQL Reference, go to the Contents - it should take you there automatically. Find the chapters that deal with SQL STATEMENTS; there are lots so they are divided up alphabetically. Go to the chapter covering ALTER TABLE.

There's the syntax.

Alternatively, that first screen you see when you select your Oracle version may contain a "Quick Search" dialog. Search on "ALTER TABLE".

Ross Leishman

P.S. Practice your research skills. Forum regulars are not very tolerant of people unwilling to help themselves. And rightly so: their time is far more valuable to them than yours.

Re: Drop a hash partition [message #313044 is a reply to message #312842] Thu, 10 April 2008 08:39 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8635
Registered: November 2002
Location: California, USA
Senior Member
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/partiti.htm#7150
Re: Drop a hash partition [message #313098 is a reply to message #312848] Thu, 10 April 2008 12:24 Go to previous messageGo to next message
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
Member
Thanks I appreciate it, I found the statement.
Re: Drop a hash partition [message #649759 is a reply to message #313098] Tue, 05 April 2016 07:35 Go to previous messageGo to next message
sivaparam
Messages: 14
Registered: March 2005
Junior Member
You cannot drop a partition of a hash-partitioned table. Instead, use the coalesce_table_partition clause.

ALTER TABLE EMPLOYEE
COALESCE PARTITION;
Re: Drop a hash partition [message #649761 is a reply to message #649759] Tue, 05 April 2016 08:41 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK you are able to repeat a solution given 8 years ago but are you able to at least feedback if not thank people who help you in your previous topic?
What I can see is you are not able to read the link I gave you and format your statement.

[Updated on: Tue, 05 April 2016 08:41]

Report message to a moderator

Previous Topic: Column order not as expected
Next Topic: spool not running from sql script
Goto Forum:
  


Current Time: Wed Dec 07 16:22:33 CST 2016

Total time taken to generate the page: 0.10811 seconds